topic Re: Fix Value in Set Analysis in QlikView

Fix Value in Set Analysis

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the following expression to get the last Contract Date from the last Year we have available:

MAX({$<YEAR={'$(=MAX(YEAR))'}>}CONTACT_DATE)

What I need is to fix the year to show always the last value, in spite of any Year selection.

So if I select Year = 2017/2016/2015 I should always show the Contract Date for my last available Year.

Do you know how could I do that?

Thank you!!!

sunny_talwar — Thu, 14 Dec 2017 13:02:23 GMT

Try this

Max({$<YEAR={'$(=Max({1}YEAR))'}>}CONTACT_DATE)

Anil_Babu_Samineni — Thu, 14 Dec 2017 13:02:52 GMT

May be this?

MAX({1<YEAR={'$(=MAX(YEAR))'}>}CONTACT_DATE)

sunny_talwar — Thu, 14 Dec 2017 13:03:06 GMT

Or this

Max({$<YEAR={'$(=Max({<YEAR>}YEAR))'}>}CONTACT_DATE)

Ben_P — Fri, 15 Dec 2017 15:40:12 GMT

If you are wondering why people are using {1} instead of {$}, it would be worth familiarizing yourself with set identifiers.

$ = currently selected values

1 = all values in the data, irrespective of current selections