Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
stephane_kosior
Creator
Creator

QV - Error of basic formula (sum)

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

 

5 Replies
Vegar
MVP
MVP

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. 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Vegar
MVP
MVP

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?

image.pngre

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
stephane_kosior
Creator
Creator
Author

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)

Vegar
MVP
MVP

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?

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
stephane_kosior
Creator
Creator
Author

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