topic Re: Expression Lable in QlikView

Expression Lable

upaliwije — Mon, 09 Jun 2014 16:01:59 GMT

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 — Mon, 09 Jun 2014 16:04:56 GMT

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

PrashantSangle — Mon, 09 Jun 2014 16:08:56 GMT

Try,

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

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

Regards,

upaliwije — Mon, 09 Jun 2014 16:09:47 GMT

Tks