Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can list all calendar field values in a variable and use the variable in your set modifier.
Set vClearCalendar = month, weekNo, Day, DayName, Monthnumber;
Example use:
Sum({<$(vClearCalendar), month={'Feb'}>} Amount)
You can list all calendar field values in a variable and use the variable in your set modifier.
Set vClearCalendar = month, weekNo, Day, DayName, Monthnumber;
Example use:
Sum({<$(vClearCalendar), month={'Feb'}>} Amount)
Thank you very much, it worked