Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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]

 

Labels (1)
3 Solutions

Accepted Solutions
Highlighted
Master
Master

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

Highlighted
Contributor III
Contributor III

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

Cheers

View solution in original post

Highlighted
Master
Master

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
Highlighted
Master
Master

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

Highlighted
Contributor III
Contributor III

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

Cheers

View solution in original post

Highlighted
Master
Master

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