Differences in data

DestinedTale — Sat, 16 Nov 2024 04:06:33 GMT

Hi, i have an expression num(sum({$<MT_I={"Y"},[Product Group]=>}[Billable Boxes])/sum({$<[Product Group]=>} TOTAL <Customer,Month, [Product Group]> [Billable Boxes]),'0.0%') which will give me 9.3%.

But when i separate the expression which is the same. But the data is 9.8% instead of 9.3%

EX1 expression is num(sum({$<MT_I={"Y"},[Product Group]=>}[Billable Boxes]),'0.0%')

EX2 expression is num(sum({$<[Product Group]=>} TOTAL <Customer,Month, [Product Group]> [Billable Boxes]),'0.0%')

Re: Differences in data

marcus_sommer — Wed, 20 Mar 2019 12:19:35 GMT

Both calculations are not the same if the expression-results for any part is 0 or NULL. I think if you used all 3 expressions within the object and adds some more granular dimensions to your table you will detect those data which cause the differences.

- Marcus

topic Re: Differences in data in QlikView

Differences in data

Re: Differences in data