# New to Qlik Sense

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for
Did you mean:
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 Type Order Value xy 464 zta 543 zkb 343 xy 545 zta 5435 zkb 434
Labels (1)
• ### Qlik Sense

3 Replies
Contributor III
Author

So the total of order value (zta + zkb )

Partner - Master III

Hi @Qlik_Bio06 ,

Maybe this:

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

I hope it can help.
Best Regards

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

Tags
Community Browser