Hide a column in a pivot table based on a variable selected

[#1]

Hi does anyone have any examples of how to set up a variable (Y or N), select it in an input box, and then have a column in a pivot table hide or show dependent on the value selected? Many thanks

[#2]

I don't know about way to do it but you can do it with straight table by using in conditions.

[pover]

Yeah, you can do this easier with the straight table, but with a pivot table I can think of 2 options:

1. Use a marco that enables and disables expressions (http://community.qlik.com/forums/t/19257.aspx)

2. Create duplicate copies of your pivot tables with different expressions and toggle the show condition of the graphs with a variable.

Regards, Karl

[#4 · Accepted solution]

Take a look at my example here http://community.qlik.com/media/p/91101.aspx

[#5]

Nick

Thanks very much - that'll do it!