topic Re: Get the values based on filtered data in other fields using set analysis in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

sunny_talwar — Mon, 15 Aug 2016 17:48:12 GMT

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

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

Anonymous — Tue, 16 Aug 2016 11:02:17 GMT

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

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

Anonymous — Tue, 16 Aug 2016 17:37:15 GMT

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