topic Re: Date from and to selection in Qlik Learning Discussions

Date from and to selection

Wed, 04 Feb 2015 12:52:11 GMT

Hi All,

I have a date column. My requirement is to create a selection where user will select from and to date.

Based on this selection data should displayed in between this from and to date.

I have tried by using calender object but not able to create from and to selection.

Could anybody help me on this??

Thanks,

Shailesh

alexandros17 — Wed, 04 Feb 2015 12:54:53 GMT

Try using 2 input boxes for date From and Date To then compare your date to this 2 Others

let me know

Wed, 04 Feb 2015 13:34:34 GMT

Hi Alessandro,

If i do so, i can get two dates as from and to.

But how i should make to select data which should displayed between only these two dates??

Agis-Kalogiannis — Wed, 04 Feb 2015 13:40:12 GMT

You can use two calendar objects with two variables

vMinDate and vMaxDate

and a set analysis expression

sum({$<Year={'>=$(vMinDate)<=$(vMaxDate)'}>}Sales)

Something like that will work

Agis

alexandros17 — Wed, 04 Feb 2015 13:40:48 GMT

In your chart if you have a dimension that contains that date then :

If(Date >= DateFrom and Date <= DateTo, Date, Null())

and check the box "Suppress null values"

if you do not have this dimension, you have to control the date in the expression

jpenuliar — Wed, 04 Feb 2015 14:28:38 GMT

Have a look at attached sample file by Colin Albert(K3FDS)

Thu, 05 Feb 2015 08:00:34 GMT

Thank you all.

Now it working properly.

Regards,

Shailesh