Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik_Bio06
Contributor III
Contributor III

Set Analysis / Sum Function

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 TypeOrder Value
xy464
zta543
zkb343
xy545
zta5435
zkb434
Labels (1)
3 Replies
Qlik_Bio06
Contributor III
Contributor III
Author

So the total of order value (zta + zkb )

agigliotti
Partner
Partner

Hi @Qlik_Bio06 ,

Maybe this:

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

I hope it can help.
Best Regards

gkhetan
Contributor II
Contributor II

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