# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
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.

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
MVP

## 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

MVP

## Re: Help tutorials for Qlik Sense

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

Contributor

## Re: Help tutorials for Qlik Sense

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,

Contributor

## Re: Help tutorials for Qlik Sense

Dear Mr. Bill,

This help tutorials for qlikview not qlik sense.

MVP

## 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.

Honored Contributor II

## Re: Help tutorials for Qlik Sense

Hi Rolf,

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

Thanks,

Sangram.

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.