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

 

 

 

2 Replies
tresesco
MVP
MVP

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.