Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mukesh19
Contributor II
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
Partner
Partner

Syntax is

Aggr(Expression with Set analysis, Dimension)

View solution in original post

6 Replies
sunny_talwar

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

pradosh_thakur
Master II
Master II

Set Analysis in the Aggr function

hope this helps you.

Learning never stops.
shraddha_g
Partner
Partner

Syntax is

Aggr(Expression with Set analysis, Dimension)

View solution in original post

ishanbhatt
Creator II
Creator II

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
Master II
Master II

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.

Learning never stops.
ArchanaB
Contributor III
Contributor III

Hi ,

 

How Can I apply set analysis to Dimensions used inside Aggr function . My formula is below :

aggr(RangeSum(ABOVE(Sum({<$(vSet),HACKETT_TEVA_SAVING={$(vExpFilterByHACKETT_TEVA)}>}SAVINGS_ACTUAL),0,RowNo())),SAVINGS_CATEGORY,ACTUAL_DATE)

 

I want to apply $(vSet) in set analysis to Actual_date dimension as well . I tried using it but it doesnt give me any output.