Qlik Sense - Group by and sum import QVD

[LordGrim]

Hi - I seem to be struggling with something very simple. Normally I will do in SQL but QVD not sure about this:

Want a GroupBy code and then Sum(price * qty) for each distinct. The result I am getting thus far is giving me all the codes and different sums for each (which is correct). I want to end with a single code and calculated value for each.

LOAD
code,
price,
qty
FROM [lib://CellTotalCost.QVD]

[Taoufiq_Zarra · Accepted solution]

Maye be ?

LOAD
code,
sum(price*qty) as New_Sum

FROM [lib://CellTotalCost.QVD]
group by code;

[LordGrim · Accepted solution]

Yes thanks very much just what I wanted...so simple when it works. 

Cheers

[Taoufiq_Zarra · Accepted solution]

Great

Now can you close the thread with appropriate answers as correct and helpful for references.