Same expression but different results

[r_wroblewski]

Dear Community,

Can someone give me a hint why the same expression give different results when I use it in pivot table & text box?

The result in the pivot table is the correct one but I don't understand why using a text box give me a wrong result.

The data is loaded from QVDs and all expressions show correct results, compared to original QlikView application, except the one expression above. Did someone has a hint or idea what could be the problem ?

Best regards,

Ronny

PS: Unfortunately I can't share the QVF or reproduce the error in a separate file until now.

[r_wroblewski]

Dear Henric

Creating a "CopyOfKeyField" in the correct table in Sense will return the correct result.

Nevertheless, I played around a little bit with the tables in the script and what I found out is that

A) the result in the pivot table is regardless of the position of the table in the load script. When use [FY] as dimension and Count({<[FY]={$(=Max([FY]))}>} ItemCode) as measure the result is every time the same, in my case 397,701.

B) the result in the text/kpi object depends on the position of the table inside the load script & will return the result only for the FIRST loaded table. In my case the measure Count({<[FY]={$(=Max([FY]))}>} ItemCode) return the value of Table A  (6,424 ItemCodes) or Table B (397,701 ItemCodes) in dependence which table is loaded first in the load script.

I also checked it in QlikView and I observed the same behavior for the text object and pivot table.

One more time I learnt something I didn't know before but need to be aware in the future.

Best regards,

Ronny

PS: Dear Henric if you still want to see the application itself please let me know & I will share it but I think this is a general behavior, I just didn't know until now. If possible, it also would be great if you can write a short reply why pivot table and text/kpi object show this different behavior.