Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need any help help tutorials for Qlik Sense to use the pivot table with aggregation.
I try the aggregation which I used in QlikView but it doesn't working ?!
Example:
=sum(aggr(( ( sum(Quantity * Price) ) ),
[Example01],
[Example02]))
this aggregation work fine in qlikview but doesn't working in Qlik Sense.
I would say:
Sure, the total is not the value you expected because the expression is wrong.
your expression
sum(Qty+vQty)*Sum(Unit Price +vPrice)
sums all Quantitys (plus the variable) and multiplizes them tith the sum of all unit prices
The correct expression should be
sum ((Qty+vQty)*(Unit Price+vPrice))
so that in each line the quantity value is multiplized by the unit price and than the aggregation sum is done
Regards
QlikView and Qlik Sense are case sensitive. Are you sure the names you are using are correct? I would also try to reduce the excessive use of parenthesis.
=Sum(Aggr(Sum(Quantity * Price), [Example01], [Example02]))
I don't see a reason, why the above expression won't work in Qlik Sense
This Technical Brief QlikView Technical Brief - AGGR.docx explains the usage of the Aggr() function.
Dear Mr. Sunny,
I try many times but it doesn't working ! I dunno if I make any mistake but in QlikView it's working fine.
Best Regards,
Awadah
Dear Mr. Bill,
This help tutorials for qlikview not qlik sense.
The Qlik functions are communal QlikView vs. QlikSense, and there is often more information on Qlik functions in QlikView forums as opposed to QlikSense forms.
Hi Rolf,
Try using the expressions with put the preceding "=" sign.
Thanks,
Sangram.
I would say:
Sure, the total is not the value you expected because the expression is wrong.
your expression
sum(Qty+vQty)*Sum(Unit Price +vPrice)
sums all Quantitys (plus the variable) and multiplizes them tith the sum of all unit prices
The correct expression should be
sum ((Qty+vQty)*(Unit Price+vPrice))
so that in each line the quantity value is multiplized by the unit price and than the aggregation sum is done
Regards