Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER 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 , ',')