Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

awadah25
Contributor

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
Valued Contributor II

Re: Help tutorials for 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

7 Replies

Re: Help tutorials for Qlik Sense

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

Re: Help tutorials for Qlik Sense

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

awadah25
Contributor

Re: Help tutorials for Qlik Sense

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

awadah25
Contributor

Re: Help tutorials for Qlik Sense

Dear Mr. Bill,

This help tutorials for qlikview not qlik sense.

Re: Help tutorials for 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.

reddys310
Honored Contributor II

Re: Help tutorials for Qlik Sense

Hi Rolf,

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

Thanks,

Sangram.

martinpohl
Valued Contributor II

Re: Help tutorials for 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

Community Browser