Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Date from and to selection

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

1 Solution

Accepted Solutions
jpenuliar
Valued Contributor III

Re: Date from and to selection

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

6 Replies

Re: Date from and to selection

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

let me know

Not applicable

Re: Date from and to selection

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

Employee
Employee

Re: Date from and to selection

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

Re: Date from and to selection

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
Valued Contributor III

Re: Date from and to selection

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

Not applicable

Re: Date from and to selection

Thank you all.

Now it working properly.

Regards,

Shailesh

Community Browser