topic select dimension in QlikView

select dimension

Anonymous — Wed, 19 Nov 2014 13:07:21 GMT

hi,

i work with two pivot tables.

i need to chose in one table dimension (ordernum),

& i need that in the secend table will apear only the dimension (profile) that apear in the first table exm:

table1:

ordernum - profile - date.....

123 11111

123 22222

456 33333

789 11111

table 2:

profile - station1 - station2.....

11111 123.2 2222

22222 1111 23232

33333 1111 252

if i will select ordernum 123 in table 1- i expect that in table 2 will apear profile - 11111,22222

is it possible ?

thanks'

yarin

marcus_malinow — Wed, 19 Nov 2014 13:10:36 GMT

Yarin,

this is the default QlikView behaviour.

Marcus

Wed, 19 Nov 2014 13:12:27 GMT

In Qlikivew every selection applies to the whole document not just that chart (unless you specifically code it not to).

PrashantSangle — Wed, 19 Nov 2014 13:13:20 GMT

Hi,

If you have proper data modeling

Then this will be easily acheive.

Just create Two chart as per requirement.

Regards

Wed, 19 Nov 2014 13:16:17 GMT

Hi Yarin ,

its by default feature of Qlikview. that it will show the values according to selection. Maybe i didn't understand the question correctly

With Regards

Harshita Gaur

ste_berbenni — Wed, 19 Nov 2014 13:24:00 GMT

Hi Yarin,

If the field "profile" is the same in both pivot table the selection in the first pivot table condition the results of the second pivot table.

Regards,

Stefano