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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calender From and to Dates as variables

Hi there,

I have created many reports with the calendar object setting variables for search in the reports where a vToDate and vFromDate is set using the object.  I however have a requirement that when nothing is found in the set date that no data should be displayed instead of all the data in the data file.  Is this possible with the calendar object at all using variables and search?

Regards,

Christo Kruger

2 Replies
Not applicable
Author

An option in order to load no data instead of all data would be to use the Calculate condition of the object, and in the calcualted condition used something along the lines of getselectedcount() function for example - this will only show if the count of your parameter within the function is greater than a count you specificy, such as

GetSelectedCount("date([Dt])") = 1  - this exampale will only load data if there is at least one date selected.  You can string together using or statements to test different and/or multiple fields

Not applicable
Author

Thanks Adam, this works beautifully.