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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Praveen89
Partner - Contributor
Partner - Contributor

Based on variable need to create from and to calander object

I need to create from and to calander objects with date field using variables in QlikView 

When user select the date range using from and to calander dates then the QlikView dashboard need to fiter it.

Labels (1)
1 Reply
morgankejerhag
Partner - Creator III
Partner - Creator III

It is common to create calendar tables to have the user select different time periods in different ways. If you really need this variables solution I would create two variables vFrom and vTo and then use them in set expressions like

sum({<Date={">=$(vFrom)<=$(vTo)"}>} Amount)

You may get into trouble with formats of dates there!