topic Previous year Data analysis in App Development

Previous year Data analysis

GaneshLakshman — Tue, 30 Apr 2019 15:19:41 GMT

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

Re: Previous year Data analysis

Vegar — Tue, 30 Apr 2019 15:27:35 GMT

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)

Re: Previous year Data analysis

GaneshLakshman — Thu, 02 May 2019 04:05:26 GMT

Thank you very much, it worked