Discussion Board for collaboration related to QlikView App Development.
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.
Go to Solution.
First of all do this thing for the sheet.
Please find the attachment for QVW file.
View solution in original post
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.
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.