Conditions in a pivot table for click action on button

[#1]

Hello,

I have two different pivot tables, one which shows monthly data, second shows YTD data and the third shows MAT. Is it possible to create three separate buttons which changes the values in one pivot table. like in the image.

[Gysbert_Wassenaar · Accepted solution]

Yes, that's possible. Add the three expressions to the pivot table and use the Conditional show option of the expressions to show/hide the expressions as needed. You can use a variable for this and set that value of the variable using Set Variable actions assigned to the buttons. See this blog post for more information: Enhancing the User Experience Using Conditional Expressions. Or this discussion: http://community.qlik.com/message/400099#400099