Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Straight table Hyperlinks to be Display Values in Pivot table

case 1: hyperlink to each value for  the column  "Variance". Such that after clicking on that hyperlink value the pivot table should pop up.

case 2:Pivot table here should show only non matching values.

ABVariance
13211
11110
24-2
320

Here Variance column values should Act like a Hyperlink(11,0,-2,0).on clicking should displat pivot table with only matching columns

2 Replies
Gysbert_Wassenaar

That is not possible. If you click on a value of an expression in a chart then all the dimension values of the same row are selected. If you click on the value 11 then value 13 is selected in field A and value 2 is selected in field B. No pivot table will pop up. You can try creating a conditional display expression for the pivot table to show/hide it depending on the number of selected values in field A and/or B. You can use the getpossiblecount function for this purpose.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Thanks Gysbert for your Quick Response.i have 6 Dimensions & 3-Expressions in st.table if we select variance suppose 11 it should display values in some other object with non matching say(1,3) rows remaining matching 2,4 rows not to be diplayed.Any chance of possiblities to achieve this.