Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Show date 12months prior to start date

I would like to display the date 12 months prior to the start date.

Start_New =(">$(=AddMonths(Max(Start_New),-12, 'MMM-YY')"))

am i close????

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Show date 12months prior to start date

my solution:  addmonths(NNAV_StartDate, -12)

View solution in original post

4 Replies
Highlighted
Partner
Partner

Re: Show date 12months prior to start date

Start_New ={">$(=date(AddMonths(Max(Start_New),-12), 'MMM-YY'))"}

Highlighted
Contributor III
Contributor III

Re: Show date 12months prior to start date

This didnt work.  I have had a bit of play and came up with this, however it is showing the value as 'zero' and not the date.

Start_New=('$(=date(addmonths(max(Start_New),-12), 'DD-MM-YYYY'))')

 

 

Highlighted
Partner
Partner

Re: Show date 12months prior to start date

hi

do you try this is set analysis

 

Highlighted
Contributor III
Contributor III

Re: Show date 12months prior to start date

my solution:  addmonths(NNAV_StartDate, -12)

View solution in original post