how can make two fields sum

[#1]

Hi all,

I am beginer in QlikView, have one excel file with two fields. current inventory and unit cost. load file in QlikView. how can make sum on these fields?

= (current inventory * unit cost)

Thank you

[tresesco]

Load CurrentInventory, UnitCost, CurrentInventory * UnitCost as NewField

From ....;

If you want to use Sum() function then that too can be implemented easily using "Group By".

If you still have any issue, you can upload your sample application .

Regards, tresesco

[#3]

go to properties menu check the check box in partial sum

[#4]

I can not do this ! I Work with QlikView from two days, now learn :)bIf give me video tutorial, will help me too.

When select vendor number, sum all articles and show total sum =(unitCost*CurrentInventiry), for a vendor. I will be happy if someone help me.

Link for files http://chichebiev.com/temp/

[#5]

I did it ! Thanks