topic Re: Kind Of between function using DATES in QlikView

Kind Of between function using DATES

Anonymous — Thu, 29 Nov 2012 11:18:34 GMT

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)

???????

Re: Kind Of between function using DATES

Thu, 29 Nov 2012 11:37:25 GMT

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)))

Re: Kind Of between function using DATES

vgutkovsky — Thu, 29 Nov 2012 13:34:18 GMT

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

Re: Kind Of between function using DATES

Thu, 29 Nov 2012 13:58:41 GMT

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

regards

Re: Kind Of between function using DATES

Anonymous — Thu, 29 Nov 2012 14:16:30 GMT

Thanks Vlad, it works fine.

Thanks layal.

Re: Kind Of between function using DATES

vgutkovsky — Thu, 29 Nov 2012 14:46:28 GMT

No problem, please verify correct answers

Re: Kind Of between function using DATES

Anonymous — Thu, 29 Nov 2012 14:47:46 GMT

i checked the answers