topic Re: set analysis not working on pivot table in QlikView

set analysis not working on pivot table

cafcptg2011 — Tue, 27 Jan 2015 18:39:37 GMT

Hi,

I need to get the sales before, during and after given promotion, I'm stuck because of my set analysis expression doesn't work properly,

I have this:

and I need this:

my set analysis is this:

the before expression is:

=sum({$< SalesDate = {">=$(=Date(Start-20,'DD-MM-YYYY')) <=$(=(date(Start,'DD-MM-YYYY')))"}>} Qty)

Can someone help me please,

thanks in advance,

CAFC

Anonymous — Tue, 27 Jan 2015 22:38:41 GMT

Try using "if" instead of set analysis:

sum(if(SalesDate>=Start-20 and SalesDate<=Start, Qty))

Wed, 28 Jan 2015 02:44:59 GMT

Hi,

Please provide the sample data, so that we can help you in better way

@Sub2u

jagan — Wed, 28 Jan 2015 05:40:07 GMT

Hi,

You need to use the If() instead of set analysis, because set analysis calculates at chart level not by row level, so you have use below expression

sum(if(SalesDate>=Date(Start-20,'DD-MM-YYYY') and Date(Start,'DD-MM-YYYY'), Qty))

Hope this helps you.

Regards,

Jagan.

cafcptg2011 — Wed, 28 Jan 2015 16:42:41 GMT

thanks your solution is correct!

thank you very much for your help!

Cafc

cafcptg2011 — Wed, 28 Jan 2015 16:44:35 GMT

thanks for help