sum ( if )

[#1]

Hi

Is there any other calculation for the following expression.

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

Thank you.

[shree909]

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

[#3]

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,

[its_anandrjs]

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)

Or

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

Provide any sample then it will more clear.

Regards

Anand

[#5]

Hi Anand,,

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

Thank you,

[its_anandrjs]

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

Regards

Anand

[#7]

[#8]

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

[SunilChauhan]

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

[its_anandrjs]

Then try with this

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

Regards

Anand