Discussion Board for collaboration related to QlikView App Development.
Im having this table for examle:
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) -
or like this:
i know i probably need to use Agrr but dont know how/
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.
its dont worked good at my origin data.
what i aventualy tried and probably worked good was: