Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I am getting 28. Could you share your sample qvw that shows 29?
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
Regards,
Brett