qlikview

Combining tables in sql/qlikview

Is it possible to combine 2 tables with a join or similar construct so that all non matching field in one group. Some thing like this: All employees with a department name gets their real department and all with no department ends up in group "Other". Department: SectionDesc ID Dep1 500 Dep2 501 Employee: Name ...

Qlikview Publisher

I have a sheduled Job in Qlikview Publisher which is failing. The log returns the following: 846791 2009-11-25 09:51:40 Normal Information The Source Document is being reloaded. DocumentPath=E:\QlikView\Customers\GRS\PurchasingDashboardBackEnd.qvw 846821 2009-11-25 09:52:13 Normal Warning The QlikView Engine working with document "...

Non-standard joins in QlikView?

Lately we have been testing QlikView in the office. The first impression is good: it has an attractive interface and performs very fast. We want to use it as a database frontend for our customers. We are also trying to determine whether it can take over parts of our relational database structure. However, we are in doubt whether its data...

Qlikview joins that doesn't join on all matching column names

Hi! I'm new to Qlikview and looking for some answers regarding scripting. How can I create Qlickview joins that just join on a specific column (and not all that are having a matching name)? Let's say that I'm having the following tables: Employee Id | Person | DepartmentID | Flags 1000 , Bob , 2001 ...

Creating a semantic layer in QlikView

I am trying to figure out if there's a way to create a semantic layer, similar to what you can do with Catalogs in Cognos and Universe in SAP-Business Objects, in QlikView. I am fairly certain that it is not something that you can do out of the box but I am wondering if there isn't a creative way to achieve the same through a combinati...

How to avoid creating a date island in QlikView?

Hey guys, I'm a beginner developer and I have a database which has several different dates. Created Date Converted Date Lost Date Changed Date etc. The data needs to be shown in one application and filter on all dates. I am coding in QlikView and I could create and date island and use their native set analysis to use filter the data, b...

quikview ocx problems

Hi there, I have the "luck" to work with quikview, and I have to control it via the ocx component qlikOCX. I've imported the the OCX component into my (delphi 2009) IDE, and now I can simply drag an TQlikOCX object to my form and use it. Unfortunately, when I do something simple like procedure TForm1.Button1Click(Sender: TObject); be...

Delphi - application with activeX control causes "appcrash"

Hello, I have to use an ActiveX Object (QlikOCX.ocx). So I've created a very small sample application, which works fine, but when I close the application I get an error like this: "application.exe doesn't work anymore -> Search online for an solution and close the programm -> Close the programm Problem details: Problem-event-name: APP...