topic Re: Dashboard default filter in QlikView

Dashboard default filter

didierodayo — Tue, 05 Jul 2016 10:30:19 GMT

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

Re: Dashboard default filter

MindaugasBacius — Tue, 05 Jul 2016 10:37:39 GMT

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.

Re: Dashboard default filter

susovan — Tue, 05 Jul 2016 11:09:19 GMT

Hi,

First of all do this thing for the sheet.

Please find the attachment for QVW file.

Re: Dashboard default filter

nilapril2010 — Tue, 05 Jul 2016 11:24:55 GMT

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

Re: Dashboard default filter

chetanpatel — Thu, 08 Oct 2020 22:16:51 GMT

Where you passing value =MAT