topic Pivot table and button in QlikView

Pivot table and button

Thu, 19 Apr 2012 14:06:19 GMT

Hi,

I would like build a button who enable or disable a metric in a pivot table.

do you know how to do that?

Example ; Pivot table

Dim1, Dim2, Metric1, Metric2

When the user clic on the button the pivot table structure become:

Dim1, Dim2, Metric1

Thu, 19 Apr 2012 14:15:43 GMT

Which version are you using?

Thu, 19 Apr 2012 14:21:17 GMT

Version 10

Thu, 19 Apr 2012 14:26:20 GMT

Ah. Well You could create a new table then and show hide each table based on the button.

Version 11 allows for conditional expressions, which would be easier.

For either the button would have an action for set variable.

you could use an if statment like this to set it:

=if(vFlag=0,1,0)

Then the condition would be:

$(vFlag)=1