Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.