Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Take a look at my example here http://community.qlik.com/media/p/91101.aspx
I don't know about way to do it but you can do it with straight table by using in conditions.
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
Take a look at my example here http://community.qlik.com/media/p/91101.aspx
Nick
Thanks very much - that'll do it!