topic Re: Qlik Sense - Group by and sum import QVD in App Development

Qlik Sense - Group by and sum import QVD

LordGrim — Mon, 20 Dec 2021 21:32:42 GMT

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]

Re: Qlik Sense - Group by and sum import QVD

Taoufiq_Zarra — Fri, 20 Mar 2020 11:44:09 GMT

Maye be ?

LOAD code, sum(price*qty) as New_Sum FROM [lib://CellTotalCost.QVD] group by code;

Re: Qlik Sense - Group by and sum import QVD

LordGrim — Fri, 20 Mar 2020 12:01:23 GMT

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

Cheers

Re: Qlik Sense - Group by and sum import QVD

Taoufiq_Zarra — Fri, 20 Mar 2020 12:49:57 GMT

Great

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