Solved: Indirect Set Analysis and Greater Than - Page 2 - Qlik Community

Report Inappropriate Content · ‎2012-02-01

Hello all.

Concept:

I have a document containing various information about clients, sales, etc.

As part of my load, I also have a separate data construct called protocols, which are not directly linked to clients/etc. but contain a set of metric definitions.

In this example, I am needing to pull all Clients from the current selection who have a Age within the bounds specified by ProtocolGroup_ID = 1.

The following expression works:

=count({$<ClientAge=P({1<ProtocolGroup_ID={'1'}>}AgeMin)>} DISTINCT ClientID)

The expression above works to provide a count of all Clients in current selection who have an age matching the AgeMin value designated by the ProtocolGroup_ID. I need it to provide a count of all Clients who have an age Greater Than or Equal to the AgeMin value.

I have been unable to get it working.

Any insight would be most appreciated.

Thank you in advance for your time and consideration.

Report Inappropriate Content · ‎2012-02-03

I was able to get it working.

Thanks!

And thanks to everyone who stopped by to help out.