topic Is it possible to create expandable expressions? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-expandable-expressions/m-p/183451#M48708 <HTML><HEAD></HEAD><BODY><P>Mike,</P><P>in version 9, you can specify show condition for the chart columns, and you can use buttons with actions to set them on and off. Before version 9, the only way to hide or show columns is via macros.</P><P>cheers,</P><P></P></BODY></HTML> Fri, 11 Dec 2009 03:31:46 GMT Oleg_Troyansky 2009-12-11T03:31:46Z Is it possible to create expandable expressions? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-expandable-expressions/m-p/183450#M48707 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P>I have a requirement to show a total figure based on 5 values. We would like to provide them with the total value but then be able to let them "show" or hide 5 columns based on those values i.e</P><P>Total = 10, ValueA = 2, ValueB = 5, ValueC = 1, ValueD = 0, ValueE = 1</P><P>Is it possible to show the Total Value and then allow the user to expand the expression to show the 5 values in 5 columns. Very much like the Subtotals function in Excel.</P><P>Thanks for your help in advance</P><P>Mike</P></BODY></HTML> Thu, 10 Dec 2009 23:36:38 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-expandable-expressions/m-p/183450#M48707 2009-12-10T23:36:38Z Is it possible to create expandable expressions? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-expandable-expressions/m-p/183451#M48708 <HTML><HEAD></HEAD><BODY><P>Mike,</P><P>in version 9, you can specify show condition for the chart columns, and you can use buttons with actions to set them on and off. Before version 9, the only way to hide or show columns is via macros.</P><P>cheers,</P><P></P></BODY></HTML> Fri, 11 Dec 2009 03:31:46 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-expandable-expressions/m-p/183451#M48708 Oleg_Troyansky 2009-12-11T03:31:46Z