Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

upaliwije
Contributor II

Expression

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Expression

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')

4 Replies
MVP
MVP

Re: Expression

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')

Not applicable

Re: Expression

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


Try the above

Re: Expression

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

upaliwije
Contributor II

Re: Expression

Thanks all

Community Browser