topic Calculate label expression in QlikView https://community.qlik.com/t5/QlikView/Calculate-label-expression/m-p/178561#M45713 <HTML><HEAD></HEAD><BODY><P><I></I></P><P></P><P></P><P>I am using the below statement for a calculated dimension, I would like to the label to display the calculated monthname or Month/Year from the below expression.</P><P>sum</P><P></P><P></P>({&lt;FYYear=, FYMonthName=,MonthSequenceNum={<B><I>$(=only(MonthSequenceNum)-1)</I></B>}&gt;} POS_Amount, -2, -3, -4..... <P>I have the additional fields in my calendar table. Any suggestions?</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 08 Sep 2009 18:20:20 GMT karensmith 2009-09-08T18:20:20Z Calculate label expression https://community.qlik.com/t5/QlikView/Calculate-label-expression/m-p/178561#M45713 <HTML><HEAD></HEAD><BODY><P><I></I></P><P></P><P></P><P>I am using the below statement for a calculated dimension, I would like to the label to display the calculated monthname or Month/Year from the below expression.</P><P>sum</P><P></P><P></P>({&lt;FYYear=, FYMonthName=,MonthSequenceNum={<B><I>$(=only(MonthSequenceNum)-1)</I></B>}&gt;} POS_Amount, -2, -3, -4..... <P>I have the additional fields in my calendar table. Any suggestions?</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 08 Sep 2009 18:20:20 GMT https://community.qlik.com/t5/QlikView/Calculate-label-expression/m-p/178561#M45713 karensmith 2009-09-08T18:20:20Z Calculate label expression https://community.qlik.com/t5/QlikView/Calculate-label-expression/m-p/178562#M45714 <HTML><HEAD></HEAD><BODY><P>Maybe this?</P><P style="padding-left:30px;">only({&lt;FYYear=,FYMonthName=,MonthSequenceNum={$(=only(MonthSequenceNum)-1)}&gt;} FYMonthName)</P><P>However, since you already have only(MonthSequenceNum), if that is connected to one and only one FYMonthName, I think it might be this easy:</P><P style="padding-left:30px;">only(FYMonthName)</P><P></P></BODY></HTML> Wed, 09 Sep 2009 03:06:52 GMT https://community.qlik.com/t5/QlikView/Calculate-label-expression/m-p/178562#M45714 johnw 2009-09-09T03:06:52Z