Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mukesh19
New Contributor II

Set analysis inside the Aggr()

Hi all,

Can anyone help me how to use set analysis inside the Aggr()

Regards,

Mukesh

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Set analysis inside the Aggr()

Syntax is

Aggr(Expression with Set analysis, Dimension)

5 Replies
MVP
MVP

Re: Set analysis inside the Aggr()

What is your expression what are you trying to do? Can you provide a sample?

pradosh_thakur
Valued Contributor III

Re: Set analysis inside the Aggr()

Set Analysis in the Aggr function

hope this helps you.

shraddha_g
Honored Contributor III

Re: Set analysis inside the Aggr()

Syntax is

Aggr(Expression with Set analysis, Dimension)

ishanbhatt
Contributor II

Re: Set analysis inside the Aggr()

Hey Mukesh,

Use below Expression syntax to implement Set Analysis in Aggr function.

=Aggr(Sum( {<EmpStatus={'Active'} >}Sales), SalesRep).

Change the Expression according to your data.

Thanks,

Ishan

pradosh_thakur
Valued Contributor III

Re: Set analysis inside the Aggr()

hi mukesh

let us know if you are satisfied with the answer by marking it correct or helpful or assume answered .if not please dont hesitate to ask more questions.