topic Re: QV - Error of basic formula (sum) in QlikView

QV - Error of basic formula (sum)

stephane_kosior — Thu, 02 May 2019 13:38:45 GMT

Hi,

There is something I don't understand. Please have a look of the file attached and you will see that the sum of a Table is different of the same table but with an additional dimension (JSNO - Journal)!!

Any idea why ?

Thank you

Re: QV - Error of basic formula (sum)

Vegar — Thu, 02 May 2019 13:51:38 GMT

My guess is that you are presenting your totals as sum of rows and not expression total and that some transactions are linked to more than one JSNO - Journal dimension value.

Re: QV - Error of basic formula (sum)

Vegar — Thu, 02 May 2019 13:58:49 GMT

Consider this script:

Colors:
Load * inline [
Fruit, Color
Apple, Red
Apple, Green
Apple, Yellow
Banana, Yellow
Strawberry, Red]
;

Transactions:
Load
Fruit,
Quantity

inline [
Fruit, Quantity
Apple, 100
Strawberry, 200
Banana, 300]
;

It will result in these two tables (upper part of picture). Below I've added a table using sum Quantity with the two different total sum methods. Do you see and understand the difference?

Re: QV - Error of basic formula (sum)

stephane_kosior — Thu, 02 May 2019 16:03:43 GMT

Unfortunatly this is not the problem because this is not a problem of doing the sum of the column ... but the sum itself. I mean there are two lines and by doing the sum in a text box should give me the right value (7658 instead of 3829 only)

Re: QV - Error of basic formula (sum)

Vegar — Thu, 02 May 2019 16:11:34 GMT

I don't really flow you? I don't see the figures 7658 and 3829 in the picture you provided.

Could you please try to explain the issue again with other words and/or picture?

Re: QV - Error of basic formula (sum)

stephane_kosior — Thu, 02 May 2019 16:16:07 GMT

Have found the solution by creating a concatenate field ... thank you guys