topic Sum and set expression wrong result in QlikView

Sum and set expression wrong result

arhadisqlik — Mon, 11 Nov 2019 11:03:04 GMT

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

tresB — Mon, 11 Nov 2019 11:20:41 GMT

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

Brett_Bleess — Thu, 14 Nov 2019 13:52:48 GMT

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

Regards,
Brett