Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
orenyahel
Contributor
Contributor

Sum and Multiply of fields (Aggr???)

Hey,

Im having this table for examle:

  

Work OrderMonthcostQtyExt Cost
P160000Jan-1650201000
P160001Jan-16101001000
P160002Feb-1670201400
P160003Feb-16505250
P160004Feb-1660402400
P160005Mar-161010100
P160006Mar-163020600
P160007Mar-1615575
P160008Mar-1620480

and im trying to get in a chart the Sum of Ext Cost per each month.

ext cost = cost*qty

while what im trying to get is somthing like that : Sum(cost*Qty) per month and to get that final chart (not in Pivot, cuz i want to use it in graph) -

 

MonthExt Cost
Jan-162000
Feb-164050
Mar-16

855

or like this:

Capture.JPG

i know i probably need to use Agrr but dont know how/

please help/

tnx,

Oren

2 Replies
adamdavi3s
Master
Master

Hi Oren,

You don't need aggr for this, Qlik will just aggregate it for you

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

This will help users identify the answers should they come across this thread in the future.

orenyahel
Contributor
Contributor
Author

Hi adam,

its dont worked good at my origin data.

what i aventualy tried and probably worked good was:

=sum(Aggr(Cost*Qty,WorkOrder))