topic Re: Expression in QlikView

Expression

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

In my pivot table I have following expression label which is working well

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

But this expression label is not working

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

pls some one advise me what is wrong with 2nd label

swuehl — Mon, 09 Jun 2014 16:31:37 GMT

You are subtracting 1 from the field at a time it seems only be having text representation, try

='Introduced' & ' '&Date(addmonths(Date#(ONLY(C_YEAR_MONTH),'M-YYYY'),-1),'MMM-YY')

Mon, 09 Jun 2014 16:31:38 GMT

='Introduced' & ' '&Date(addmonths(Date#(ONLY(C_YEAR_MONTH),'M-YYYY'),-1),'MMM-YY')

Try the above

MK_QSL — Mon, 09 Jun 2014 16:43:43 GMT

='Introduced' & ' '&Date(AddMonths(Date#((ONLY(C_YEAR_MONTH)),'M-YYYY'),-1),'MMM-YY')

upaliwije — Mon, 09 Jun 2014 16:43:44 GMT

Thanks all