Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In a pivot table, when a value is selected, the table shrinks down to just the selection.
Is there a way to keep the pivot table box displaying all values and just indicate the selection with a highlight ?
Hi Gerry,
I think so, it's not possible in Qlikview
Hi,
Try something below:
Sum({1}sales)
OR
Sum({<FRY14A=,Period=>}Sales)
HTH
Sushil
Use set analysis to exlude selection
so even after selecting the value in table, you want to just high light the selected and show all the data some what similar to list box.
I think its not possible in qlikview. its the property in QV for tables that only selected value will be displayed and others will be hidden