Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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!

 

 

Labels (5)
3 Replies
Highlighted
Specialist
Specialist

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.

Highlighted
Specialist III
Specialist III

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

 

 

Highlighted
Contributor III
Contributor III

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.