topic Dynamically changing label for comparative analysys in QlikView https://community.qlik.com/t5/QlikView/Dynamically-changing-label-for-comparative-analysys/m-p/374095#M139217 <HTML><HEAD></HEAD><BODY><P>Can't you use <SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;"> Max({state2}year)?</SPAN></P></BODY></HTML> Wed, 30 May 2012 08:47:32 GMT 2012-05-30T08:47:32Z Dynamically changing label for comparative analysys https://community.qlik.com/t5/QlikView/Dynamically-changing-label-for-comparative-analysys/m-p/374094#M139216 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In Qlikview 11 there is a new feature called alternate state. I am using it to create some comparative analysis. Basically, I have two listboxes containing field 'Year' in different states. I was able to compare sales on a bar chart in different years by select them on the two listboxes. The two expressions I am using are</P><P>Label: =(Year)</P><P>Definition: Sum({state1}sales)</P><P></P><P>Label:=(Year)</P><P>Definition: Sum({state2}sales)</P><P></P><P>I would like to change the label when a different year is selected. For example. When I select 2011, 2011 should appear for the label. That's why I have made Label=(Year). However, I am only able to make it change in one state. Anyone knows how to make label change for both states?</P><P></P><P>Regards,</P><P>Xue Bin</P></BODY></HTML> Wed, 30 May 2012 08:33:25 GMT https://community.qlik.com/t5/QlikView/Dynamically-changing-label-for-comparative-analysys/m-p/374094#M139216 2012-05-30T08:33:25Z Dynamically changing label for comparative analysys https://community.qlik.com/t5/QlikView/Dynamically-changing-label-for-comparative-analysys/m-p/374095#M139217 <HTML><HEAD></HEAD><BODY><P>Can't you use <SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;"> Max({state2}year)?</SPAN></P></BODY></HTML> Wed, 30 May 2012 08:47:32 GMT https://community.qlik.com/t5/QlikView/Dynamically-changing-label-for-comparative-analysys/m-p/374095#M139217 2012-05-30T08:47:32Z Dynamically changing label for comparative analysys https://community.qlik.com/t5/QlikView/Dynamically-changing-label-for-comparative-analysys/m-p/374096#M139218 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>It works:) Thanks. Any idea how to deal with the situation when more than one year are seleted? </P><P></P><P>Regards,</P><P>Xue Bin</P></BODY></HTML> Wed, 30 May 2012 09:02:48 GMT https://community.qlik.com/t5/QlikView/Dynamically-changing-label-for-comparative-analysys/m-p/374096#M139218 2012-05-30T09:02:48Z Re: Dynamically changing label for comparative analysys https://community.qlik.com/t5/QlikView/Dynamically-changing-label-for-comparative-analysys/m-p/374097#M139219 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Try using getfieldselections(year) as the label </SPAN></P></BODY></HTML> Thu, 09 May 2013 06:39:06 GMT https://community.qlik.com/t5/QlikView/Dynamically-changing-label-for-comparative-analysys/m-p/374097#M139219 ashkrit501 2013-05-09T06:39:06Z