topic Re: Sum for previous year in QlikView

Sum for previous year

gautik92 — Wed, 25 Nov 2020 16:16:04 GMT

I have Chart whic am using to compare current year and previous year

my requirement is like if i select some dates in calendar it should show sum for cy and py

for cy it is working fine

am confused with previous year calculation

i should show sum of previous year for those selected dates

Anil_Babu_Samineni — Wed, 18 May 2016 10:52:15 GMT

Share me one example please

sunny_talwar — Wed, 18 May 2016 10:53:55 GMT

Look into As Of Table: The As-Of Table

Anonymous — Wed, 18 May 2016 11:01:20 GMT

Hi,

Perhaps something like:

For Current year: =Sum({$<Year={$(=Max(Year))}>}Sales)

For last Year:-= =Sum({$<Year={$(=Max(Year)-1)}>}Sales)

gautik92 — Wed, 18 May 2016 11:07:51 GMT

this is to get previous year

but my requirement is lik if i select some dates in calendar i should get sum for same dates in previous year