topic Re: Aggregation in Qlik Sense in App Development

Aggregation in Qlik Sense

poojashribanger — Fri, 18 May 2018 06:38:11 GMT

Hi,

I have date and 3 measure

by default total of qlik sense is giving me wrong numbers .

i have attached image please check

Re: Aggregation in Qlik Sense

kaushiknsolanki — Fri, 18 May 2018 06:46:20 GMT

Hi,

Try aggr function like below.

Sum(Aggr(Sum(XYZ),Date))

Regards,

Kaushik Solanki

Re: Aggregation in Qlik Sense

poojashribanger — Fri, 18 May 2018 06:57:02 GMT

same thing if i want to do in bar chart .

where i have dimension quarter(inline loaded) and measure is like

if(dim='M1',exp,

if(dim='M2',exp,

if(dim='M3',exp,

if(dim='M4',exp))))

how to implement here

Re: Aggregation in Qlik Sense

kaushiknsolanki — Fri, 18 May 2018 06:59:13 GMT

Hi,

Then your if statement will be

if(dim='M1',Sum(Aggr(exp),Dim),

if(dim='M2',Sum(Aggr(exp),Dim),

if(dim='M3',Sum(Aggr(exp),Dim),

if(dim='M4',Sum(Aggr(exp),Dim)))))

Regards,

Kaushik Solanki

Re: Aggregation in Qlik Sense

poojashribanger — Fri, 18 May 2018 07:04:47 GMT

not working for me

because even dimension i am calculating

if(timeline='M1','FY'&right(YearStart(AddYears(max([Date]),-1),0,4),2),

if(timeline='M2','FY'&right(YearStart(AddYears(max([Date]),-1),-1,4),2)))

Re: Aggregation in Qlik Sense

jonathandienst — Fri, 18 May 2018 07:10:07 GMT

Measure with ratios or the DISTINCT keyword are usually not additive, so the sum of rows is not equivalent to the expression calculated at the total level (which is what Qlik does by default). To get a column sum, use and Aggr() function with all the pivot table dimensions with this pattern:

Sum(Aggr(.... your expression ...., dim1, dim2, ...))

Insert your expression in the placeholder above and include all the chart dimemension