The Operating Room application that we (Qlik consultant / myself) built has a business requirement to default all the visualizations to a rolling 13 months and be flexible enough to allow ad-hoc Surgery Dates selections for any date range. For example, if we ran the app today, 4/21/2017, the “Top 20 Procedures” chart would render for 3/1/2016-3/31/2017 by default (done in the set analysis). If I then selected the data filter for Jan 2015, Jan 2016 and Jan 2017 then application renders data for only Jan 2015, Jan 2016 and Jan 2017 (respects additional filters).
This requirement is accommodated by the vDateFilterIsRollingOrAdHocDtSelection variable which contains a nested “if statement” that evaluates the GetSelectedCount of the date filter (mmm yyyy). Since the app has 25 sheets with multiple visualizations on each page, this logic is repeated 100+ times. It seems like a more efficient alternative might be to set the selected value of the month year date filter thereby eliminating the set analysis logic for vDateFilterIsRollingOrAdHocDtSelection. In this method, the selection would occur dynamically (either as application was rendered or in the daily data load refresh). If the selection could be default based on today’s date, the complexity of the application could be reduced significantly. Is there an OnLoad event or another trigger I can utilize? What alternatives are available? I opened up multiple support requests ( Ref: 01064834 / Ref: New 01077917) but didn’t get the issue resolved so any assistance you can provide would be greatly appreciated.
