Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yarin,
this is the default QlikView behaviour.
Marcus
In Qlikivew every selection applies to the whole document not just that chart (unless you specifically code it not to).
Hi,
If you have proper data modeling
Then this will be easily acheive.
Just create Two chart as per requirement.
Regards
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
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