topic Re: if no selection made, default to max PeriodID in QlikView

if no selection made, default to max PeriodID

laureadiaz — Sat, 16 Nov 2024 20:44:06 GMT

Hello,

I need help with website loading speed. If no selections are made, can I make graphs/tables default to the max Period ID?

Something with get field count I am thinking?

Thanks!

Sergey_Shuklin — Tue, 04 Jun 2019 08:23:06 GMT

Hello!

You can use this Set Analysis condition in your expressions for getting max period when nothing is selected:

{<PeriodID = {"$(=max(PeriodID))"}>}

Or you can try to use a Bookmark with selected max period and trigger it when document is open.

kkkumar82 — Tue, 04 Jun 2019 10:44:48 GMT

Adding to the comments

Better to use Getselectedcount() for period

if(GetSelectedCount()=0,

Use the Max function as suggested above in set analysis

Use your function as it is with out using Period ID field in set analysis

laureadiaz — Tue, 04 Jun 2019 12:55:12 GMT

Thanks!

Do I need to GetSelectedCount for each date field; ie. day, week, month, and year nested if style?

Also can I use this as a condition for the dimension/expression; ie, properties>dimensions>enable conditional?

I never seem to get those to work, haha.