Set Analysis help

Tue, 08 Mar 2016 18:44:47 GMT

Hello,

Im currently trying to compare 2 years among 3 years information is available.

For example, i got information from 2014,2015 and 2016. And i got 2 main columns, that one displays the information from a year and another from another year.

What im trying to do, is put on the first column the Min(Year) available, and Max(Year) on the second column.

In this case, if nothing is selected the first column would have the information from 2014 and the last from 2016. If you select 2014 and 2015, the first one remains with 2014, but the second one changes to 2015.

Im currently trying something like this

sum({$<Year={"=$(=Min(Year))"}>}amount) and sum({$<Year={"=$(=Max(Year))"}>}amount)

The problem is this doesn't seam to matter, since is the same result if i used sum(amount). Can anyone help me with the proper way to do thius?

thanks alot,

Re: Set Analysis help

sunny_talwar — Tue, 08 Mar 2016 18:48:22 GMT

Can you try these:

Sum({$<Year={$(=Min(Year))}>} amount)

Sum({$<Year={$(=Max(Year))}>} amount)

Re: Set Analysis help

Tue, 08 Mar 2016 19:03:24 GMT

thanks alot, worked prefectly, i knew i was close xd

topic Re: Set Analysis help in QlikView

Set Analysis help

Re: Set Analysis help

Re: Set Analysis help