topic Re: Need help Set analysis in QlikView

Need help Set analysis

Mon, 24 Dec 2012 13:09:25 GMT

Hello Friends,

As I am trying to write a expression using set analysis but I am not getting any reslut.

The thing is I have two calculated fields from the script and trying to find a a sales.

eg:

=Sum({$<Disc={'Discount'}, MoreDisc={'ExtraDiscount'}>}[Sales])

and tryed like using If contion

=Sum(if(Disc='Discount',[Sales])) + Sum(If(MoreDisc='ExtraDiscount',[Sales]))

Thanks in advnce for your help

Regards

Chriss.

er_mohit — Mon, 24 Dec 2012 13:29:22 GMT

using aggr function like

aggr(rangesum({$(<Disc ='Discount'{${MoreDisc='ExtraDiscount'}>}},Sales)))

hope it helps you

jagan — Mon, 24 Dec 2012 14:04:57 GMT

Hi,

Please try below expression

=Sum({<Disc={'Discount'} > + <MoreDisc={'ExtraDiscount'}>} [Sales])

Hope it helps you.

Regards,

Jagan.

Wed, 26 Dec 2012 09:52:48 GMT

Hello Jegan and Mohit,

Thanks for your solutions,

Mohit: still your expression is not working for me, its showing error in as highlighted

aggr(rangesum({$(<Disc ='Discount'{${MoreDisc='ExtraDiscount'}>}},Sales)))

Regards

Chriss

shilpan — Tue, 01 Jan 2013 03:09:43 GMT

Try this

aggr(rangesum({$(<Disc ={'Discount'} + MoreDisc={'ExtraDiscount'}>},Sales)))

Hope it helps,