I'm developing an Qlik Sense app in which I have to show the previous years data based on the date range selected.
I'm ignoring some dimensions like this: sum({<SY=, [SY.WkNoYear] = , Date = , DateFriendly = ,........})
But the problem I'm facing is that the calendar table has many other dimensions like month, weekNo, Day, DayName, Monthnumber etc and if the user selects any of these dimensions from the "Selections" my expression would break.
Is there a simple way to include all the fields to ignore without making the expression too long so that user has the flexibility to select any dimension?