Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
didierodayo
Partner - Creator III
Partner - Creator III

Dashboard default filter

Hello all,

I have a dashboard running slow because of the it is loading close to 80million records. A chart on the dashboard has student_id  and start_date as dimension My question is the following

How can I force users to select Month/Year on opening if they would like to view the data based on all student_id.

If the user doesn't want to analyse all the records then HOW can I allow them to switch from MonthYear default filter to Student_ID?

This is because the document is faster when 1 or few student_ids are selected OR when the MonthYear date is selected from the dynamic calendar.

I really welcome any suggestion.

Thanks

1 Solution

Accepted Solutions
susovan
Partner - Specialist
Partner - Specialist

Hi,

First of all do this thing for the sheet.

40.JPG

Please find the attachment for QVW file.

38.JPG39.JPG

Warm Regards,
Susovan

View solution in original post

4 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Screenshot_2.jpg

Try using triggers for fields Year and Month.

Also, you could Lock the fields.

Besides, if dashboard contains multiple tabs consider using OnLeaveSheet action Clear All.

susovan
Partner - Specialist
Partner - Specialist

Hi,

First of all do this thing for the sheet.

40.JPG

Please find the attachment for QVW file.

38.JPG39.JPG

Warm Regards,
Susovan
nilapril2010
Contributor III
Contributor III

Simple

In expression condition write the following condition

GetSelectedCount(FieldName) > 0

If user make any selection, the GetSelectedCount(FieldName) will be possitive and your chart expression will be executed. Otherwise your chart expression will not be executed.

Regards

Nilanjan

chetanpatel
Contributor III
Contributor III

Where you passing value =MAT