# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

## Re: Expression

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

4 Replies
MVP

## Re: Expression

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

Not applicable

Try the above

MVP