Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator III

question on grabbing a date in a text box

I have a list of dates as below, with 4/30/2017 being the most recent/maximum date.

How do I grab in a text box a comma separated list of dates going back 12 months ?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try expression like:

=Concat( Distinct {<Record_Date={'>$(=Date(AddMonths(Max(Record_Date),-12)))'}>} Record_Date , ',')

View solution in original post

1 Reply
tresesco
MVP
MVP

Try expression like:

=Concat( Distinct {<Record_Date={'>$(=Date(AddMonths(Max(Record_Date),-12)))'}>} Record_Date , ',')