topic Re: Set Analysis within Set Analysis within SetAnalysis in QlikView

Set Analysis within Set Analysis within SetAnalysis

jeckstein — Fri, 03 Feb 2017 17:13:11 GMT

I have the following equation

(sum({<[Date]={"$(=Max(Date))"}>}Sessions)

This is giving me the sum of Sessions where the date is the max date.

But the only dates that should qualify for max date is where sum(Sessions) on that day is greater then 0.

Meaning if I have the following table

I want my result to be 3. This is the max date where sessions is greater then 0.

Thanks in advance,

sunny_talwar — Fri, 03 Feb 2017 17:16:32 GMT

May be this:

Sum({<[Date]={'$(=Max({<Date = {"=Sum(Sessions) > 0"}>}Date))'}>} Sessions)

jeckstein — Fri, 03 Feb 2017 17:19:48 GMT

Sunny,

That did not seem to work

sunny_talwar — Fri, 03 Feb 2017 17:20:32 GMT

My bad, I just changed it... try this:

Sum({<[Date]={'$(=Max({<Date = {"=Sum(Sessions) > 0"}>}Date))'}>} Sessions)

Anonymous — Fri, 03 Feb 2017 17:23:53 GMT

is this also ok?

Sum({<[Date]={"=((Date=Max(Date)) and (Sum(Sessions)>0))"}>} Sessions)