Qlik Sense App Development

Contributor II

Aggregation in Qlik Sense

Hi,

I have date and 3 measure

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

i have attached image please check

1 Solution

Accepted Solutions

Re: Aggregation in Qlik Sense

Hi,

Try aggr function like below.

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

Regards,

Kaushik Solanki

5 Replies

Re: Aggregation in Qlik Sense

Hi,

Try aggr function like below.

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

Regards,

Kaushik Solanki

Contributor II

Re: Aggregation in Qlik Sense

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

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

Contributor II

Re: Aggregation in Qlik Sense

not working for me

because even dimension i am calculating

like