topic Re: Button to Change Pivot table view in QlikView

Button to Change Pivot table view

Mon, 24 Mar 2014 17:05:56 GMT

Is there a way to create a button to change the view of a pivot chart on a specific sheet? Basically, the pivot chart, by default has 5 expressions, I want the user to be able to click a button to change the view to only show 3 of the 5 expressions and click it again to go back to the default view.

Is this possible? If so, how?

Thanks in advance.

Re: Button to Change Pivot table view

Mon, 24 Mar 2014 17:18:24 GMT

Just use variables, so set up a variable (i.e. vShowExpressions). Create a button and add an action to set the variable equal to 1. In your pivot table set the expressions you want to hide to be conditionally shown when vShowExpressions = 1. Set the button to be visible when vShowExpressions = 0. Then create a second button that is visible when vShowExpressions= 1 and add a action to set the variable back to 0.

Re: Button to Change Pivot table view

alexandros17 — Mon, 24 Mar 2014 17:20:07 GMT

yes it is easy

1) define a variable ex. LET myVar = 0;

2) in the expression use conditional show and write in the textbox: myVar = 1

3) add a button and trigger action -> external -> set variable

in the upper text box write myVar

in the lower text box write: =if(myVar=0,1,0)

reload and enjoy

Re: Button to Change Pivot table view

maxgro — Mon, 24 Mar 2014 17:27:09 GMT

I think Alessandro has already answered; if you want further extend have a look to

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table

Re: Button to Change Pivot table view

Mon, 24 Mar 2014 17:48:00 GMT

Thanks! Where in Add Action do I set to be visable when vShowExpression = 1 ??

Re: Button to Change Pivot table view

Mon, 24 Mar 2014 17:51:06 GMT

you can make the button visible on the Layout tab, set Show to be conditional and add vShowExpressions = 1 as the condition or you can do as Alessandro suggested and just use the one button and use an if statement to switch the variable between 1 and 0.

Re: Button to Change Pivot table view

srchilukoori — Mon, 24 Mar 2014 20:07:10 GMT

Use conditional enabling to show/hide the expressions, and a button to set this variable.