topic problem with sum formula in QlikView

problem with sum formula

Tue, 21 Jun 2011 15:06:22 GMT

Hello All,

I have a table with following fields

ACT:

Week, Product_family, Qty.

I have another table

SUM_ACT:

Week,

Product_Family,

sum(QTY) as quantity

resident ACT

group by Week,Product_Family;

Now i try to pull the above two tables in different table boxes. Now logically, The sum should only sum it up, If any of the Week and Product_Family are repeated. Now what happens here is that the sum is different that the one that i can see in the table box of ACT. Can some one explain the reason

Arif

problem with sum formula

erichshiino — Tue, 21 Jun 2011 16:34:16 GMT

Hi,

Using QV you don't need to create the SUM_ACT table at the script level. You could just use a chart (as a straight table, for example) and include week and product_family as dimensions and sum(Qty) as an expression.

-----

In your case, you have all the the behavior in the table box because it will show you all the possible values in a line.

You could go to table properties -> presentation tab, select some fields and check 'Omit rows where field is null' to get the results you are looking for.

Hope this helps,

Erich