Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tiyasa125
Contributor II
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
neelamsaroha157
Specialist II
Specialist II

It is hard to suggest anything without a sample file.