Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

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

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

1 Solution

Accepted Solutions
Not applicable

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

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

4 Replies
Not applicable

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

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

Luminary
Luminary

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

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

Not applicable

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

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

Not applicable

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

Nick

Thanks very much - that'll do it!