5 Replies Latest reply: Sep 3, 2013 9:12 AM by Steve Zagzebski

# Set Analysis - Reporting Dates

I am an expression that is working well:

sum({<^CustProducer = {"=[Commission Producer CummPerc]<=\$(vRetensionPct)"}>} Commission)

However I need to add a further requirement to the expression.  I have a field called ProdGLMonth and need to add extra filter ot the set analysis that basically does the following:

Where ProdGLMonth is between [Reporting Begin Month] and [Reporting End Month]

• ###### Re: Set Analysis - Reporting Dates

If ProdGLMonth, [Reporting Begin Month], [Reporting End Month] are months created using QlikView or numbers try the following expression:

sum({<^CustProducer = {"=[Commission Producer CummPerc]<=\$(vRetensionPct)"},ProdGLMonth = {">=[Reporting Begin Month]<=[Reporting End Month]"}>} Commission)

Regards, Karl

• ###### Re: Set Analysis - Reporting Dates

Thanks Karl!

I have difficulty with dates. I thought they all three fields were dates so I wouldn't have to use any num function.

• ###### Re: Set Analysis - Reporting Dates

Try this:

sum({<^CustProducer = {"=[Commission Producer CummPerc]<=\$(vRetensionPct)"}, ProdGLMonth = {">=\$(=num([Reporting Begin Month])) <=\$(=num([Reporting End Month]))"}>} Commission)

assuming ProdGLMonth is a number presenting month.

Hope this helps

Herman

• ###### Re: Set Analysis - Reporting Dates

Opps....I was late....

• ###### Re: Set Analysis - Reporting Dates

Yeap, but you're right.  I forgot to add the dollar-sign expansion and the num function to my set analysis.

Regards, Karl