topic How do I choose total? in QlikView

How do I choose total?

Wed, 20 Jan 2010 03:53:27 GMT

I am a Chinese,My English is very poor?

Product Code	Inventory Qty	Sales Amt	Sales Qty	Sales Price	Inventory Value
Product-A	100	10000	1000	10	1000
Product-B	200	80000	1000	80	16000
Product-C	300	90000	1000	90	27000
Total	600	180000	3000	60	44000

product code ?inventory qty?sales amt?sales qty is dimensions
sales price is expression? sales amt / sales qty
inventory value is expression?inventory qty * sales price

i use Pivot chart.
total line have a problem
total sales price = total sales amt / total sales qty is OK.
total inventory value = total inventory qty * total sales price = 36000
BUT total inventory value is 1000+ 16000 + 27000 = 44000

There should be two kinds of totals.

A: use total line (eg.total sales price = total sales amt / total sales qty )

B: sum colume(eg.total inventory value is 1000+ 16000 + 27000 = 44000)

How do I choose?

qlikview is choose A.

My English is very poor, Do you understand my expression ?

How do I choose total?

Wed, 20 Jan 2010 05:25:42 GMT

The difference between the two expressions is that in first one you are adding the values first and then multiplying them, where as in second one you multiply and calculate the sum of the inventory value,

The second one is correct because it will give you sum of inventory value.

Also in the Pivot table you can select the Show Partial Sum from the Presentation tab.

How do I choose total?

Wed, 20 Jan 2010 05:47:50 GMT

Thanks for your promptly reply.

in this case
A: use total line (eg.total sales price = total sales amt / total sales qty )
adding the values first and then multiplying them

B: sum column(eg.total inventory value is 1000+ 16000 + 27000 = 44000)
multiply and calculate the sum of the inventory value,

select the Show Partial Sum from the Presentation tab
The result is A