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: 
Anonymous
Not applicable

Returning no data for calendar date range

Hello,

I have a pair of calendar objects (Start and End Date) controlled by a Button object, to filter a dataset where the Timestamp is > Start Date and < End Date (the expression for the button object - on the Timestamp field - is below); the filtering works fine, but the user wants the table which displays the dataset to be empty if there are no Timestamp values between the Start and End Date values. I believe this request to be against "standard" Qlikview logic - if there is no matching Timestamp value, then there is no filter to apply, so Qlikview displays all the data. Is there a way to "force" Qlikview to do something different and suppress all data if there is no Timestamp for the given date range? The script contains no specific code to build a master calendar - I am aware that master calendar code could be written to populate the calendars only with dates where Timestamp values exist, but I'm wondering if there's a way to suppress all data (i.e. display an empty table) if no Timestamp values match the given date range?

Expression for button object to filter dataset on the Timestamp field:

='>='&date(VDateMin , 'DD/MM/YYYY') & '<='&date(VDateMax+1 , 'DD/MM/YYYY')

Thanks,

VB

3 Replies
krishna_2644
Specialist III
Specialist III

Its possible.

if you disable the xpressions on the conditions based on your requirement. you can force the chart to display no data.

Post a demo document so that i can play around and repost you with the solution,if possible in your scenario.

Thanks

Anonymous
Not applicable
Author

Thanks for your response - I cannot provide a demo document as the data is sensitive. Can you clarify what you mean by "disable the expressions on the conditions" - do you mean provide an Enable Condition on the button?? if so, what should I put there? Sorry, but I don't understand what you mean. Thanks.

krishna_2644
Specialist III
Specialist III

Exactly.

Apply some 'Enable conditions' on your chart expressions so that the expressions get disbaled when there are no Timestamp values between the Start and End Date values.