Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
GaneshLakshman
Contributor III
Contributor III

Previous year Data

Hi,

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?

Thanks

0 Replies