tag:blogger.com,1999:blog-74781587740146944372024-09-14T19:08:53.301-07:00Unknownnoreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7478158774014694437.post-27598755469571445082009-09-27T05:07:00.000-07:002009-09-27T05:49:13.238-07:00

QlikView is a great new reporting tool that approaches Business Intelligence in quite a different way than the established Business Intelligence tools like IBM Cognos and SAP BO.The main differences between QlikView and mainstream Business Intelligence tools are that QlikView has:Super fast In-Memory ProcessingMore intuitive way of linking dataIntegrated ETL BackendFurthermore, QlikView is very

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7478158774014694437.post-488790290191513022009-09-27T03:00:00.000-07:002009-09-27T08:23:05.106-07:00

When two loaded tables in a QlikView script have an identical fieldname, QlikView uses this field as a Key, and creates a relationship between the two tables. If two tables share two identical fields, QlikView does not create a direct relationships, but instead creates a synthetic table that stands in between the two tables.Assuming that these two fields in the two tables are indeed key fields

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7478158774014694437.post-3820258228138697072009-09-26T08:23:00.000-07:002009-09-27T08:32:04.203-07:00

The QlikView Script automatically creates one table from two source tables when the fields all have exactly the same name. Although this behavior can be precisely what you want, it can also be pretty annoying. In your Table Viewer you will only find the first table, because the second one is automatically integrated with the first one.In situations where you want to keep the identical field names

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7478158774014694437.post-68748880584790775632009-09-26T08:00:00.000-07:002009-09-27T08:33:00.692-07:00

Concatenating is the process of putting two tables together.When two tables have exactly the same fields, concatenation is done automatically by Qlikview. So the following source tables will result in one QlikView table:LOAD A,BFROM file1.csv;LOAD A,BFROM file2.csv;This can be avoided by using the Noconcatenate statementIf two tables do not have exactly the same fields, concatenation is still

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7478158774014694437.post-35461369212324915252009-09-26T05:59:00.000-07:002009-09-27T06:22:33.182-07:00

The QlikView Script creates relationships between tables automatically based on identical field names. Sometimes this can be exactly what you want, but in many instances links will be created where you don't want them.An example of an automatic link that you don't want to have, is a relationship between the address field for customers and the address field for company locations. Since probably

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7478158774014694437.post-62664863610228885142009-09-26T05:27:00.000-07:002009-09-27T05:49:33.254-07:00

When loading tables through your script, QlikView automatically creates relations between tabels based on the names of the fields. If a fieldname is identical in two tables , the QlikView Script will assume this is a key field, and create a relation.In most realistic situations, your sources will not be completely consistent, so some of the names in different tables should be linked although

Unknownnoreply@blogger.com0