topic Re: Returning no data for calendar date range in QlikView

Returning no data for calendar date range

Anonymous — Tue, 13 Oct 2015 13:23:03 GMT

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,

Re: Returning no data for calendar date range

Qrishna — Tue, 13 Oct 2015 13:27:23 GMT

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

Re: Returning no data for calendar date range

Anonymous — Tue, 13 Oct 2015 13:59:18 GMT

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.

Re: Returning no data for calendar date range

Qrishna — Tue, 13 Oct 2015 14:03:01 GMT

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.