Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator III

pivot table presentation question

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 ?

Pivot1.PNG.png

Pivot2.PNG.png

4 Replies
qv_testing
Specialist II
Specialist II

Hi Gerry,

I think so, it's not possible in Qlikview

sushil353
Master II
Master II

Hi,

Try something below:

Sum({1}sales)

OR

Sum({<FRY14A=,Period=>}Sales)

HTH

Sushil

sujeetsingh
Master III
Master III

Use set analysis to exlude selection

vardhancse
Specialist III
Specialist III

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