topic Re: Set Analysis in QlikView

Set Analysis

rathnam_qv — Fri, 25 Oct 2013 10:13:02 GMT

Hi all,

i havetwo expressions

=sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]={'Albany'}>}[DEPOSIT SUM]) / sum({<NAME={'ABC Bank'}>}[DEPOSIT SUM])

in my first expression i am calculating sum(DEPOSIT SUM) for 'ABC Bank' and [ ASSESSMENT AREA]={'Albany'}. my problem is i want to calculate sum for all my ASSESSMENT AREA's...

how to do that...can any one help...

Thanks in advance!!!

Smiley

Re: Set Analysis

kouroshkarimi — Fri, 25 Oct 2013 10:22:42 GMT

=sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]=>}[DEPOSIT SUM]) / sum({<NAME={'ABC Bank'}>}[DEPOSIT SUM])

Re: Set Analysis

Fri, 25 Oct 2013 10:23:28 GMT

if i understand well, you want to use set analysis for every ASSESSMENT AREA.

I would suggest you to use a pivot or straight table with assesment area as dimension

and =sum({<NAME={'ABCt Bank''}>}[DEPOSIT SUM]) / sum({<NAME={'ABC Bank'}>} TOTAL [DEPOSIT SUM])

as expression

Chris

Re: Set Analysis

Fri, 25 Oct 2013 10:36:35 GMT

=sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]=>}[DEPOSIT SUM]) / sum({<NAME={'ABC Bank'}>}[DEPOSIT SUM])

Re: Set Analysis

Fri, 25 Oct 2013 10:42:26 GMT

If you want all Assessment areas, simply remove that bit of the set analysis. Thus allowing 'all' Assessment areas.

=sum({<NAME={'ABCt Bank'}>}[DEPOSIT SUM]) / sum({<NAME={'ABC Bank'}>}[DEPOSIT SUM])

Hope this helps

James

Re: Set Analysis

Fri, 25 Oct 2013 10:42:33 GMT

Why don't you try this ??

=sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]={'*'}[DEPOSIT SUM]) / sum({<NAME={'ABC Bank'}>}[DEPOSIT SUM])

Re: Set Analysis

Fri, 25 Oct 2013 10:47:57 GMT

This is also work...

both are same

Re: Set Analysis

rathnam_qv — Fri, 25 Oct 2013 11:22:30 GMT

Hi Sathia,

both expressions giving me the same values

Smiley

Re: Set Analysis

MayilVahanan — Fri, 25 Oct 2013 11:41:29 GMT

Try like this

=sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]=>}[DEPOSIT SUM]) / sum(Total {<NAME={'ABC Bank'}>}[DEPOSIT SUM])

Re: Set Analysis

Fri, 25 Oct 2013 11:44:59 GMT

sum({<NAME={'ABCt Bank'},[ ASSESSMENT AREA]={"*"}>}[DEPOSIT SUM])

try like this