topic Re: Conditions in a pivot table for click action on button in QlikView https://community.qlik.com/t5/QlikView/Conditions-in-a-pivot-table-for-click-action-on-button/m-p/783020#M1031179 <HTML><HEAD></HEAD><BODY><P>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: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/28/enhancing-the-user-experience-using-conditional-expressions" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">Enhancing the User Experience Using Conditional Expressions</A>. Or this discussion: <A _jive_internal="true" href="https://community.qlik.com/message/400099#400099" title="http://community.qlik.com/message/400099#400099">http://community.qlik.com/message/400099#400099</A></P></BODY></HTML> Wed, 11 Feb 2015 08:43:43 GMT Gysbert_Wassenaar 2015-02-11T08:43:43Z Conditions in a pivot table for click action on button https://community.qlik.com/t5/QlikView/Conditions-in-a-pivot-table-for-click-action-on-button/m-p/783019#M1031178 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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.</P><P><IMG __jive_id="77608" alt="buttons.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/77608_buttons.png" style="height: auto;" /></P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Conditions-in-a-pivot-table-for-click-action-on-button/m-p/783019#M1031178 2020-11-20T18:02:30Z Re: Conditions in a pivot table for click action on button https://community.qlik.com/t5/QlikView/Conditions-in-a-pivot-table-for-click-action-on-button/m-p/783020#M1031179 <HTML><HEAD></HEAD><BODY><P>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: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/28/enhancing-the-user-experience-using-conditional-expressions" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">Enhancing the User Experience Using Conditional Expressions</A>. Or this discussion: <A _jive_internal="true" href="https://community.qlik.com/message/400099#400099" title="http://community.qlik.com/message/400099#400099">http://community.qlik.com/message/400099#400099</A></P></BODY></HTML> Wed, 11 Feb 2015 08:43:43 GMT https://community.qlik.com/t5/QlikView/Conditions-in-a-pivot-table-for-click-action-on-button/m-p/783020#M1031179 Gysbert_Wassenaar 2015-02-11T08:43:43Z