topic Re: Query related to data model in QlikView

Query related to data model

rsdhavle — Wed, 23 Jul 2014 12:50:52 GMT

I am getting data from two tables. One contains current cube values and other has previous cube. Both has same columns as A, B , C.

When i run script as qlikview behaves it will automatically join tables on all the 3 columns. But its not displaying values when Column C is missing on some values in previous cube.

For modelling it properly should i use composite key or i should use some Join?

Re: Query related to data model

sunilkumarqv — Wed, 23 Jul 2014 12:56:37 GMT

use NoConcatenate statement in script in middle of the table

Exp:

TabA:

From datasoure...;

NoConcatenate

TabB:

From datasoure...;

Re: Query related to data model

Wed, 23 Jul 2014 13:04:01 GMT

You can also use, left keep or right keep or inner keep based on your requirement, just replace join by keep to avoid concatenation

Re: Query related to data model

rsdhavle — Wed, 23 Jul 2014 13:07:27 GMT

Thanks..just one thing addition to it..lets say i want to join these two tables on C column then what to be done?

I don't need join on other two columns

Re: Query related to data model

Wed, 23 Jul 2014 13:12:36 GMT

Just rename these columns in of the tables by using as

Re: Query related to data model

sunilkumarqv — Wed, 23 Jul 2014 13:13:33 GMT

Try like this Exp:

TabA:

From datasoure...;

Concatenate(C)

TabB:

From datasoure...;