Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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