Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 - Champion
Partner - Champion

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