Set Analysis using GetPossibleCount

timsworldroamer — Tue, 30 Sep 2014 22:20:22 GMT

Hi,

I'm trying to display a field (Item) in a listbox for only certain values that have more than 2 values from another field associated with it. See the load script below:

CompanyTable:

Load * inline

[

Item, Object

Item1, Object1

Item2, Object1

Item2, Object2

Item3, Object1

Item3, Object2

Item3, Object3

Item4, Object1

Item4, Object2

Item4, Object3

Item4, Object4

];

In this case I want to display Items that have more than two Objects associated with it, i.e. Item3 and Item4. How would I go about doing that using Set Expression? Is it possible to do so with GetPossibleCount? I have the follow but it doesn't seem to be working:

=Item & ' - ' & Count({<Item={"GetPossibleCount(Object)>2"}>}Object)

Thanks in advance for your help.

Re: Set Analysis using GetPossibleCount

JonnyPoole — Tue, 30 Sep 2014 23:54:34 GMT

How about this:

=if( aggr(count(DISTINCT Object),Item) >1, Item)

Re: Set Analysis using GetPossibleCount

timsworldroamer — Wed, 01 Oct 2014 13:55:59 GMT

Thank you Jonathan, this works. Appreciate the help.

topic Set Analysis using GetPossibleCount in QlikView

Set Analysis using GetPossibleCount

Re: Set Analysis using GetPossibleCount

Re: Set Analysis using GetPossibleCount