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:
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.