Solved: Re: Expression Lable - Qlik Community

upaliwije · ‎2014-06-09

I have following expression label

='Refunds' & ' '&(ONLY(C_YEAR_MONTH)) and resulting output is Refunds 1-2014

But want this output to appear as Refunds Jan-14

pls help me to modify the above expression label to display the desired result

MK_QSL · ‎2014-06-09

='Refunds' & ' '&Date(Date#((ONLY(C_YEAR_MONTH)),'M-YYYY'),'MMM-YY')

View solution in original post

MK_QSL · ‎2014-06-09

='Refunds' & ' '&Date(Date#((ONLY(C_YEAR_MONTH)),'M-YYYY'),'MMM-YY')

PrashantSangle · ‎2014-06-09

Try,

='Refunds' & ' '&MonthName(ONLY(C_YEAR_MONTH))

Or

='Refunds' & ' '&Date(Date#(C_YEAR_MONTH),'M-YYYY'),'MMM-YY')

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

upaliwije · ‎2014-06-09

Tks