Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello,
An example for this scenario would be better to understand.
Thanks,
Ashutosh
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.