Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

select dimension

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

5 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Yarin,

this is the default QlikView behaviour.

Marcus

Not applicable
Author

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

PrashantSangle

Hi,

If you have proper data modeling

Then this will be easily acheive.

Just create Two chart as per requirement.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

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
Partner - Contributor II
Partner - Contributor II

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