Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

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
Partner
Partner

Re: Dashboard default filter

Hi,

First of all do this thing for the sheet.

40.JPG

Please find the attachment for QVW file.

38.JPG39.JPG

View solution in original post

3 Replies
MindaugasBacius
Valued Contributor III

Re: Dashboard default filter

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.

Partner
Partner

Re: Dashboard default filter

Hi,

First of all do this thing for the sheet.

40.JPG

Please find the attachment for QVW file.

38.JPG39.JPG

View solution in original post

nilapril2010
New Contributor III

Re: Dashboard default filter

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