Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

6 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

let me know

Not applicable
Author

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

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
Partner - Champion III
Partner - Champion III

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
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

Thank you all.

Now it working properly.

Regards,

Shailesh