topic Re: Set Analysis: Where Year < Max(Year) in QlikView

Set Analysis: Where Year < Max(Year)

Anonymous — Mon, 14 Mar 2016 19:56:08 GMT

I am trying to write set analysis to calculate for items where the Year(date) on the line level is < Max(Year(Date))

Not much to show as of yet so all recommendations are welcomed.

Thank you,

- dave

Anonymous — Mon, 14 Mar 2016 20:13:31 GMT

To clarify:

For instance

Item#,Date

1, 1/15/2014

2, 2/10/2014

3, 2/11/2016

4, 3/04/2016

5, 7/23/2015

I want to only count items where the year of the date field is less than the max year of the whole date field.

In the example above I would only want to count item # 1,2 and 5

swuehl — Mon, 14 Mar 2016 20:17:18 GMT

Count( DISTINCT {<Date = {"=Year(Date)<$(=Max(Year(Date)))"}>} Item#)

Anonymous — Mon, 14 Mar 2016 20:28:09 GMT

thank you!