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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
arhadisqlik
Contributor II
Contributor II

Sum and set expression wrong result

Hi all

I have Qlikview app that uses set expression in a chart to sum across values where a condition is met - but it does not work as expected.

I have attached a spread sheet with the table data. 

I want to sum the column Kvantum where the column LinjeType = Køb.

I use this: =Sum({$<LinjeType={'Køb'}>} Kvantum). 

But the above returns 29 and should return 28.

All help and ideas are appreciated.

Best regards

Anders

 

 

 

Labels (1)
2 Replies
tresB
Champion III
Champion III

I am getting 28. Could you share your sample qvw  that shows 29?

Brett_Bleess
Former Employee
Former Employee

The only additional things I can provide are the following URLs that may have some info to help you sort things:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Quotes-in-Set-Analysis/ba-p/1471824

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.