Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
gerrycastellino
Contributor 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 ?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: question on grabbing a date in a text box

Try expression like:

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

View solution in original post

1 Reply
MVP
MVP

Re: question on grabbing a date in a text box

Try expression like:

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

View solution in original post