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

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

Sun, 20 Jun 2010 16:49:32 GMT

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

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

Sun, 20 Jun 2010 17:13:11 GMT

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

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

pover — Sun, 20 Jun 2010 20:25:58 GMT

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

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

Mon, 21 Jun 2010 15:48:29 GMT

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

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

Tue, 22 Jun 2010 22:39:09 GMT

Nick

Thanks very much - that'll do it!