topic Re: Total over previous years in QlikView

Total over previous years

g_f_bakker — Wed, 13 Jun 2012 09:29:41 GMT

Hello,

I have a question and I really need some help.

When I use a table in a bar chart with the columns YEAR, PERIOD and QTY, I want to do the following with one expression:

YEAR < Max(YEAR)

then (Total QTY of that Year)

Else Sum(QTY)

Only the bar of Max(YEAR) must change when I put a selection on PERIOD.

My test file is attached.

Please help me, I think it’s something with the aggr function, but .....

deepakk — Wed, 13 Jun 2012 09:37:35 GMT

HI,

Try out the attach application

Deepak

g_f_bakker — Wed, 13 Jun 2012 09:44:14 GMT

Hi Deepak,

Absolutely BRILLIANT!!

Could you please explain this syntax? Sum({<YEAR={"< $(vMaxYear)"},PERIOD=>}QTY)

Many thanks, Gerard.

deepakk — Wed, 13 Jun 2012 10:51:31 GMT

Hi Gerard,

I am storing the max(year) inside variable vMaxyear. And using set analysis iam checking if Year < vMaxYear

and ignore the selection for period (PERIOD=) then sum of quantity.

Deepak

g_f_bakker — Wed, 13 Jun 2012 10:55:40 GMT

Hi Deepak,

Again, many thanks!

Gerard.