Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
LordGrim
Contributor III
Contributor III

Qlik Sense - Group by and sum import QVD

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]

 

3 Solutions

Accepted Solutions
Taoufiq_Zarra

Maye be ?

LOAD
code,
sum(price*qty) as New_Sum

FROM [lib://CellTotalCost.QVD]
group by code;
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

LordGrim
Contributor III
Contributor III
Author

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

Cheers

View solution in original post

Taoufiq_Zarra

Great

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

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

3 Replies
Taoufiq_Zarra

Maye be ?

LOAD
code,
sum(price*qty) as New_Sum

FROM [lib://CellTotalCost.QVD]
group by code;
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
LordGrim
Contributor III
Contributor III
Author

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

Cheers

Taoufiq_Zarra

Great

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

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉