Automatic selection - availability of data

datanibbler — Tue, 27 May 2014 09:43:26 GMT

Hi,

my scenario is the following:

- On the sheets of my apps, I usually implement an automatic selection of the current week (as a trigger on the button activating the
worksheet)

<=> On some worksheets, there is no data available for the current week, or even for the current month (that is the issue I'm looking
at right now)

=> Though correct technically, it just looks bad to see a blank chart with that "No data available" message. Seeing the data for a past
period is not actually better, but it still makes a better impression than seeing nothing.

=> Is there some way I can set the trigger to select

- the current week if there is any data to display

- or otherwise the last week for which there is any data (might be more than one week back)?

Thanks a lot!

Best regards,

DataNibbler

Re: Automatic selection - availability of data

ashfaq_haseeb — Tue, 27 May 2014 09:47:14 GMT

Hi,

Create a back-end field with YearWeek combination, and use MAx(YearWeek) in your trigger.

Regards

ASHFAQ

Re: Automatic selection - availability of data

Tue, 27 May 2014 09:51:50 GMT

you could achieve this with max(week).

HOpe this helps you.

regards,

topic Re: Automatic selection - availability of data in QlikView

Automatic selection - availability of data

Re: Automatic selection - availability of data

Re: Automatic selection - availability of data