Set Analysis / Sum Function

[Qlik_Bio06]

Hi

how can I use the sum function to determine the total of the order value of zta and zkb?

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

Somehow I don't really understand the syntax. It would be nice if somebody could help me.

Greetings 

Ebi

Sales Order Type	Order Value
xy	464
zta	543
zkb	343
xy	545
zta	5435
zkb	434

[Qlik_Bio06]

So the total of order value (zta + zkb )

[agigliotti]

Hi @Qlik_Bio06 ,

Maybe this:

=sum( {<  [Sales Order Type] = {'zta','zkb'} >} [Order Value] )

I hope it can help.
Best Regards

[gkhetan]

Small change in above expression would be required, if total order value of (zta + zkb) is required witout honoring user selections

=sum( {1<[Sales Order Type] = {'zta','zkb'}>} [Order Value] )

Regards

GKhetan