Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Automatic selection - availability of data


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

2 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

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

Regards

ASHFAQ

Not applicable

you could achieve this with max(week).

HOpe this helps you.

regards,

MT