Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

My Table appear 2 Column of May 2013 ?

Hi All

I use below expression for label :-

May 2013 label :-

=Date(today()-90,'MMM YY')

April 2013 label :-

=Date(today()-120,'MMM YY')

Mu issue is the both above expression , it display May 2013 ?

Paul

1 Solution

Accepted Solutions
MVP
MVP

Re: My Table appear 2 Column of May 2013 ?

  Hi,

Try like this

For Apr-2013

=Date(AddMonths(today(), -4),'MMM YY')

For May-2013 

=Date(AddMonths(today(), -3),'MMM YY')

Regards,

Jagan.

2 Replies
MVP
MVP

Re: My Table appear 2 Column of May 2013 ?

  Hi,

Try like this

For Apr-2013

=Date(AddMonths(today(), -4),'MMM YY')

For May-2013 

=Date(AddMonths(today(), -3),'MMM YY')

Regards,

Jagan.

Not applicable

Re: My Table appear 2 Column of May 2013 ?

Hi Jagan

Your approach work fine. But i am very surprise , where go wrong ? I believe there are reasons for it. 

Any way thank you very much for your advise.

Paul

Community Browser