Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
laureadiaz
New Contributor III

if no selection made, default to max PeriodID

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!

 

 

3 Replies
Sergey_Shuklin
Valued Contributor

Re: if no selection made, default to max PeriodID

Hello!

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

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

optimizing_web_pic1.png

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

kkkumar82
Valued Contributor III

Re: if no selection made, default to max PeriodID

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
New Contributor III

Re: if no selection made, default to max PeriodID

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.