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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

How to write an Sum expression?

Hi guys,

I would like to write an set analysis.

i have attached screenshot.

1) i have a straight table. i have a normal expression. sum(tree_population_points).

2) i am unable to sum up correctly. It should not show 7.

3) the total sum should be 18.

so, how can i get that sum??? group by? aggr???

Rgds

Jim

1 Solution

Accepted Solutions
Anil_Babu_Samineni

It will work direct way - May be this? sum(TOTAL tree_population_points)

Or change your expression like below

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

6 Replies
Anil_Babu_Samineni

It will work direct way - May be this? sum(TOTAL tree_population_points)

Or change your expression like below

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
tresesco
MVP
MVP

Use total mode 'Sum of rows' in the expression tab.

Capture.PNG

jim_chan
Specialist
Specialist
Author

Yes, it has given me the correct figure.

Can you show me how to write in a set analysis??

Rgds

Jim

jim_chan
Specialist
Specialist
Author

Yes, it has given me the correct figure.

Can you show me how to write in a set analysis??

Rgds

Jim

jim_chan
Specialist
Specialist
Author

i have tried with sum(TOTAL tree_population_points)

it gives me the wrong value - which is 7.

Anil_Babu_Samineni

For me, It's working with simple aggregation also. Would you share sample

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful