Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor II

Plot a chart calculating with last year max period value value

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.

1 Reply
Highlighted
Valued Contributor II

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

It is hard to suggest anything without a sample file.