Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help tutorials for Qlik Sense

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.

1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

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

View solution in original post

7 Replies
sunny_talwar

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

Anonymous
Not applicable
Author

This Technical Brief QlikView Technical Brief - AGGR.docx  explains the usage of the Aggr() function.

Anonymous
Not applicable
Author

Dear Mr. Sunny,

Untitled.png

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

Anonymous
Not applicable
Author

Dear Mr. Bill,

This help tutorials for qlikview not qlik sense.

Anonymous
Not applicable
Author

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.

reddy-s
Master II
Master II

Hi Rolf,

Try using the expressions with put the preceding "=" sign.

Thanks,

Sangram.

martinpohl
Partner - Master
Partner - Master

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