Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to avoid an empty set when working through a date range?

Pulling data from a table that has values for all fields for every day within a range, with the exception of one day which has no associated data; you can assume in my scenario DATA_TS is primary key for all data.  Under this condition when I hit a defined PREV Button on my dashboard to bring up a previous days worth of data, everything is fine as long as previous day is not the empty one.  If it is the empty one my PREV Button does nothing and I am stuck on the current day of data.  The PREV Button is defined with a "Select in Field" action of =DATE(MAX(DATA_TS)-1)  -- this is to move me backwards one day at a time. 

Additionally, If I actually select this empty day with my Calendar Object it seems to corrupt all current selections given me strange results on my dashboard.  How can I exclude my PREV Button from selecting empty dates, i.e. dates that have no associated data?

To take it one step further, how can I lock out any empty set from being selected in my calendar object?

Message was edited by: Lew Goldstein

Community Browser