topic Re: sum ( if ) in QlikView

sum ( if )

Wed, 24 Dec 2014 18:21:55 GMT

Is there any other calculation for the following expression.

Sum (if (column=' name', if (column=' name', other column)calculation column)).

Thank you.

Re: sum ( if )

shree909 — Wed, 24 Dec 2014 18:55:09 GMT

Hello

WHy dont you use the set analysis. and match function to get the desired results.

or else post a sample file with the data.

Thanks

sree

Re: sum ( if )

Thu, 25 Dec 2014 13:21:33 GMT

Hi Sree,

Thanks for the reply. And expressions are below.

sum(if(SCENARIO='S1' or SCENARIO = 'JUMP-OFF' ,RWA))
sum(if(SCENARIO='S2' or SCENARIO = 'JUMP-OFF' ,RWA))
sum(if(SCENARIO='S3' or SCENARIO = 'JUMP-OFF' ,RWA))
sum(if(SCENARIO='S4' or SCENARIO = 'JUMP-OFF' ,RWA))
sum(if(SCENARIO='S5' or SCENARIO = 'JUMP-OFF' ,RWA))
sum(if(SCENARIO='S6' or SCENARIO = 'JUMP-OFF' ,RWA))

6 expressions have been used in chart. Is there any replacement for the above with qlikview functions.

Thank you,

Re: sum ( if )

its_anandrjs — Thu, 25 Dec 2014 13:47:44 GMT

You can try with

sum({<SCENARIO= {'S1'}, SCENARIO= {'JUMP-OFF'}>} RWA)

sum({<SCENARIO= {'S2'}, SCENARIO= {'JUMP-OFF'}>} RWA)

sum({<SCENARIO= {'S3'}, SCENARIO= {'JUMP-OFF'}>} RWA)

sum({<SCENARIO= {'S4'}, SCENARIO= {'JUMP-OFF'}>} RWA)

sum({<SCENARIO= {'S5'}, SCENARIO= {'JUMP-OFF'}>} RWA)

sum({<SCENARIO= {'S6'}, SCENARIO= {'JUMP-OFF'}>} RWA)

Sum({<SCENARIO= { 'S1','S2','S3','S4','S5','S6' }, SCENARIO= {'JUMP-OFF'}>} RWA)

Provide any sample then it will more clear.

Regards

Anand

Re: sum ( if )

Thu, 25 Dec 2014 14:10:09 GMT

Hi Anand,,

Only Jump off data, I can see even if I select S1.

Thank you,

Re: sum ( if )

its_anandrjs — Thu, 25 Dec 2014 14:38:25 GMT

Please explain with an example output or input as any inline table with few data.

Regards

Anand

Re: sum ( if )

Thu, 25 Dec 2014 15:11:59 GMT

Re: sum ( if )

Thu, 25 Dec 2014 15:13:13 GMT

output should come as per the above screen shots but when I applied the given formula then out put is coming like:

Re: sum ( if )

SunilChauhan — Thu, 25 Dec 2014 15:19:34 GMT

sum(if((SCENARIO='S1' and SCENARIO='S2' and SCENARIO='S3' and SCENARIO='S4' and SCENARIO='S5')or SCENARIO = 'JUMP-OFF' ,RWA))

Re: sum ( if )

its_anandrjs — Thu, 25 Dec 2014 15:26:03 GMT

Then try with this

Sum( If( Match( SCENARIO, 'S1','S2','S3','S4','S5','S6' ) And SCENARIO = 'JUMP-OFF' RWA ))

Regards

Anand

Re: sum ( if )

SunilChauhan — Thu, 25 Dec 2014 15:35:31 GMT

i thing this is oppose to requirement SCENARIO = 'JUMP-OFF' comes with or as per requirement

Sum( If( wildmatch( SCENARIO, 'S*', ) or SCENARIO = 'JUMP-OFF' RWA ))

hope this helps

Re: sum ( if )

its_anandrjs — Thu, 25 Dec 2014 15:42:11 GMT

Or may be this helps

=Sum( If( Match( SCENARIO, 'S1') And
          Match( SCENARIO, 'S3') And
          Match( SCENARIO, 'S4') And
          Match( SCENARIO, 'S5') And
          Match( SCENARIO, 'S6') And SCENARIO = 'JUMP-OFF' , RWA))

Regards

Anand

Re: sum ( if )

Fri, 26 Dec 2014 08:21:52 GMT

Hi Anand,

Its not working.

Re: sum ( if )

jagan — Fri, 26 Dec 2014 08:32:58 GMT

Hi,

Check this expression

=sum({<SCENARIO*={'S1', 'S2', 'S3', 'S4','S5', 'S6', 'JUMP-OFF'}> RWA)

Hope this helps you.

Regards,

Jagan.

Re: sum ( if )

its_anandrjs — Fri, 26 Dec 2014 08:34:42 GMT

Other wise use or

=Sum( If( Match( SCENARIO, 'S1') And
          Match( SCENARIO, 'S3') And
          Match( SCENARIO, 'S4') And
          Match( SCENARIO, 'S5') And
          Match( SCENARIO, 'S6') Or SCENARIO = 'JUMP-OFF' , RWA))

Or please provide any sample file for this will easy to understand the problem with few rows only.

Regards

Anand

Re: sum ( if )

MarcoWedel — Fri, 26 Dec 2014 10:18:41 GMT

Please post sample data

Re: sum ( if )

Sun, 28 Dec 2014 07:03:28 GMT

I will post sample data.

Thank you.