Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Previous year Data


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?