Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get the values based on filtered data in other fields using set analysis

Capture.PNG

If you will look at the above chart, Jodzis,Jeffrey M is  in the filter conditions, yet it has been assigned Rank 2.

So when I use

=(Concat
({<
[Field B] = {"=rank(Count([Field B]))=1"},
Template=
{"=rank(Count(Template)))=1"},
Name=
{"=rank(Count(Name)1,1)<=3"
>} 

Aggr(Only(Name) & ' ('&Count(Name)&')', [Field B], [Name]))) , I will only get Eagan,Caroline Burlingame(11). But I should also get all Names with count 3 and 2 like MaDonnell,,,Turner. 

3 Replies
sunny_talwar

Would you be able to share the application to look at the issue? I am not 100% sure what you are looking to get here

Anonymous
Not applicable
Author

I am so sorry cant do that due to policy issues. I will explain it further.

I have say 10 fields and among those 10 are [Field B] and Template.

So  first I need to filter which data based on max no of count in [Field B]. In other words I have to filter the dataset where [Field B]=max(count(Field B). Further I have to apply 2nd level filter on the above dataset, to filter the data based on max no of count in template .In other words 2nd level filter will beTemplate]=max(count(Template).

Once I have the filtered dataset, I have to get top 3 names. My question is how will I RETREIVE the top 3 names in the filtered dataset

Anonymous
Not applicable
Author

Can you please help on this. Need to get it working...