topic Chart with set analysis for max(year) in QlikView

Chart with set analysis for max(year)

Sat, 09 Apr 2011 17:48:48 GMT

Hi All,

I'm trying to create a chart expression to calculate sales over each month for max selected year. The expression I'm working on is:

sum({< Year = {$(=Max(Year))>} Amount)

but it shows no value. Could you please tell what needs to be changed?

Thank you,

Przemek

Chart with set analysis for max(year)

tresB — Sat, 09 Apr 2011 18:23:32 GMT

Hi, you are missing a "}"

correct expression: Sum({< Year = {$(=Max(Year))}>} Amount)

Regards, tresesco

Chart with set analysis for max(year)

Sat, 09 Apr 2011 20:18:19 GMT

Indeed, I missed it, but the issue seems to be somewhere else - still not working.

Chart with set analysis for max(year)

Oleg_Troyansky — Sat, 09 Apr 2011 21:29:44 GMT

the only way for us to find an issue "somewhere else" is to see it. If you can post an example, we could possibly examine it...

Chart with set analysis for max(year)

Sun, 10 Apr 2011 12:34:51 GMT

Attached. Hopefully it'll be helpful.

Chart with set analysis for max(year)

Oleg_Troyansky — Sun, 10 Apr 2011 22:32:13 GMT

Well, I can see a couple of problems:

1. Your Set Analysis condition had a few syntax errors - missing "=" signs, misplaced brackets, etc... The correct equasion is this:

Sum({< Rok={$(=Max(Rok))}>} Kwota)

2. In your data, you have absolutely identical values of Kwota, with positive and negative signs, so the total sum of Kwota is always equal to zero. You can only see it if you select specific values of Kwota. It's caused either by the nature of your data (zero-sum accounts?), or by the way you generated your sample data.

if you correct those two problems, you'll see monthly numbers in your chart.

Re: Chart with set analysis for max(year)

afsarshaikh — Fri, 08 Sep 2017 08:50:49 GMT

Store Max(Year) in a variable lets's say,

Varaible name = vYear

Varaible Description = =Max(Year)

So, your expression should be:

sum({< Year = {$(=vYear)}>} Amount)

Hope this works!