Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
GrantBooth
Creator
Creator

Toggle Column View in Pivot Table

I'm new to working with Qlik so apologies if this is easy and/or been answered elsewhere.

I've got Col1, Col2, Col3 in a Pivot Table and an additional Col4 which is the sum of Col1:3. I would like to be able to toggle viewing the three columns in the sum and I don't really have a starting place, any help would be greatly appreciated.

2 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

An example for this scenario would be better to understand.

 

Thanks,

Ashutosh

stevejoyce
Specialist II
Specialist II

Do you only want to toggle viewing col1-3 or controlling which columns are being summed into col4?

If it's just viewing:  There you can use the property "Show column if" of the measure.  Create a variable input, or island table list box with your toggle options.  For sake of simple implementation... have a variable that's binary vShowIndividualMeasure, and the variable input on the app can be 1/0 or Y/N.  Your columns 1-3 can have a "show column if" $(vShowIndividualMeasure) = 1.

You can expand on this for more complex controls but that would be the idea.