# 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
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

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