topic Same app giving different calc results on different PCs...same version of QV in QlikView

Same app giving different calc results on different PCs...same version of QV

pgdavis2 — Sat, 20 Nov 2010 00:21:17 GMT

I have an app that uses the following formula to show the number of days the Demand PL is positive.

count(if(aggr(sum(DemandPL),Year,Month,Day,Pnode)>0,TotalLMP_DA))

It is very strange...on my laptop the formula gives correct results. but on another PC using the same QV9 SR6, it give an incorrect result with excatly the same settings and selections.

It also happens when I save it in QV10 and open in QV10 on the other PC.

Anyone ever seen this behavior before?

Same app giving different calc results on different PCs...same version of QV

llauses243 — Sat, 20 Nov 2010 01:06:12 GMT

Hi Paul,

Pls to revise attach & compare ...

Good luck, Luis.

Same app giving different calc results on different PCs...same version of QV

pgdavis2 — Sat, 20 Nov 2010 01:32:53 GMT

Thanks for the suggestion but it did not correct the problem.

Same app giving different calc results on different PCs...same version of QV

pgdavis2 — Sat, 20 Nov 2010 02:27:42 GMT

I've looked at it now on 4 different PCs...2 get the aggr correct and 2 have it wrong. All 4 PCs are 64 bit. Changing the SR does not correct the issue.

It must either be a system setting like the date format that was suggested, or CPU related.

Same app giving different calc results on different PCs...same version of QV

pgdavis2 — Tue, 23 Nov 2010 11:38:57 GMT

I was able to clean up the data somewhat and the issue went away. Go figure.

Still, it's strange how QV handled "garbage" data differently across machines, but at least it plays nice with well constructed data! That's what matters.