Toggle Column View in Pivot Table

[GrantBooth]

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.

[AshutoshBhumkar]

Hello,

An example for this scenario would be better to understand.

Thanks,

Ashutosh

[stevejoyce]

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.