Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Kind Of between function using DATES

Hi Every one,

i'm looking to find womething to help me to get a range of dates.

for exepmle i want the dates between admonths(MyDate,-12) and addmonths(MyDate,-7)

???????

1 Solution

Accepted Solutions
vgutkovsky
Master II
Master II

You mean to dynamically generate a list of dates after a user selects something in "MyDate"? Assuming MyDate is a variable, you can create a trigger (activated, for example, on a button click, although you can also activate it through Document Properties >> Triggers on a Variable Event trigger). See attached for a very simple example.

Regards,

Vlad

View solution in original post

6 Replies
Not applicable
Author

try this ,

=(MakeDate(Year(date(MonthName(PeriodDate,-12))),Month(date(MonthName(PeriodDate,-12))),Day(PeriodDate)))

=(MakeDate(Year(date(MonthName(PeriodDate,-7))),Month(date(MonthName(PeriodDate,-7))),Day(PeriodDate)))

vgutkovsky
Master II
Master II

You mean to dynamically generate a list of dates after a user selects something in "MyDate"? Assuming MyDate is a variable, you can create a trigger (activated, for example, on a button click, although you can also activate it through Document Properties >> Triggers on a Variable Event trigger). See attached for a very simple example.

Regards,

Vlad

Not applicable
Author

yes,and u can also use these variables in set analysis if u need too.

regards

Anonymous
Not applicable
Author

Thanks Vlad, it works fine.

Thanks layal.

vgutkovsky
Master II
Master II

No problem, please verify correct answers

Anonymous
Not applicable
Author

i checked the answers