topic Straight table Hyperlinks to be Display Values in Pivot table in QlikView

Straight table Hyperlinks to be Display Values in Pivot table

Anonymous — Mon, 01 Sep 2014 12:09:41 GMT

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.

A	B	Variance
13	2	11
11	11	0
2	4	-2
3	2	0

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

Re: Straight table Hyperlinks to be Display Values in Pivot table

Gysbert_Wassenaar — Mon, 01 Sep 2014 12:22:28 GMT

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.

Re: Straight table Hyperlinks to be Display Values in Pivot table

Anonymous — Mon, 01 Sep 2014 12:34:39 GMT

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.