Plot a chart calculating with last year max period value value

tiyasa125 — Thu, 05 Jul 2018 16:09:37 GMT

Hi,

I have a weekly chart in which I need to show two years developemnt %. Now the current year weekly devlopment % is calculated against the last year max week values (all values are accumulated).

example if the last year max week is week 52 then all current year weekly development values will calculate against that.

This is a line chart so I need to ignore teh week filter.

However in the calculation I need to identify the last year max week sum value.

Here is the problem. This work fine without any period dimenstion but the moment I am using a period dimension like the Year or Week then it doesnot seems to be working. I tried with variable also.

So every time it need to look for the last year max period value and then plot the weekly chart for 2 years.

Can you please help me!

Many Thanks.

Re: Plot a chart calculating with last year max period value value

neelamsaroha157 — Thu, 05 Jul 2018 16:43:34 GMT

It is hard to suggest anything without a sample file.

topic Plot a chart calculating with last year max period value value in QlikView

Plot a chart calculating with last year max period value value

Re: Plot a chart calculating with last year max period value value