Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

pivot and straight tables

Hi....

I have two tables one is straight tables and pivot table when i select the perticular row of straight table  the pivot table should be display(like hide and show).

Can any one help me..

Thanks...

1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

This depends on the dimension of your straight table. If your straight table has one dimension only (which is not calculated but a normal field), then this selection is like selecting a listbox value of this field/dimension:

So you can go in properties of the pivot table > Layout > Show Conditional:

getselectedcount(YourField)>0   - so everytime a selection is made, the pivot table is shown

View solution in original post

7 Replies
sujeetsingh
Master III
Master III

You can use the value of the diemsion you using in your table and then set triggers.

You can set trigger Document Properties>> Triggers>>Triggers on field

and then set the action

danieloberbilli
Specialist II
Specialist II

This depends on the dimension of your straight table. If your straight table has one dimension only (which is not calculated but a normal field), then this selection is like selecting a listbox value of this field/dimension:

So you can go in properties of the pivot table > Layout > Show Conditional:

getselectedcount(YourField)>0   - so everytime a selection is made, the pivot table is shown

sujeetsingh
Master III
Master III

Here is the sample for you

Anonymous
Not applicable
Author

Hi..

  Thnks for your reply can we show pivot table based on the expression field in straight table(not based on the dimension field).

Please find following attachment...

when i select calls offered field(its a expression field) in straight table i have to display pivot table.

Thnks,

Chandini.G

danieloberbilli
Specialist II
Specialist II

I think this is not possible but maybe someone else has an idea...might be worthy to post this in a new thread

Anonymous
Not applicable
Author

Hi Daniel..

Thanks for your responce.i posted in new thread..

Thanks,

danieloberbilli
Specialist II
Specialist II

Good luck