Two Set Analysis calculations into One Expression

simongoodman — Sat, 15 Jun 2013 16:35:10 GMT

I have two separate set analysis calculations and I want to present them into one expression. I am having difficulty mainly because I am still struggling with set analysis.

Expression 1:

Sum ({$<Field={'Points'}>}Points)

Expression 2:

sum({$<Date={">$(=MonthStart(Max(RollMthYr), -12)) <=$(=MonthEnd(Max(RollMthYr)))"},Year=,Month=>} Points)

Please can someone help me.

Re: Two Set Analysis calculations into One Expression

calvindk — Sat, 15 Jun 2013 16:47:48 GMT

Is this what you want?

sum({$<

Date={">$(=MonthStart(Max(RollMthYr), -12)) <=$(=MonthEnd(Max(RollMthYr)))"},

Year=, Month=, Field={'Points'}

>} Points)

topic Re: Two Set Analysis calculations into One Expression in QlikView

Two Set Analysis calculations into One Expression

Re: Two Set Analysis calculations into One Expression