topic Re: Set Analysis - Reporting Dates in QlikView

Set Analysis - Reporting Dates

zagzebski — Tue, 03 Sep 2013 00:36:44 GMT

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

Tue, 03 Sep 2013 04:12:21 GMT

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

Tue, 03 Sep 2013 04:18:28 GMT

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

Tue, 03 Sep 2013 04:21:32 GMT

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

Re: Set Analysis - Reporting Dates

Tue, 03 Sep 2013 04:30:21 GMT

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

Regards, Karl

Re: Set Analysis - Reporting Dates

zagzebski — Tue, 03 Sep 2013 13:12:27 GMT

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.