Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
vb_qv_11
Contributor III
Contributor III

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

vb_qv_11
Contributor III
Contributor III
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.