Set Analysis to report "Select Excluded"

GavK — Mon, 08 Jul 2024 13:15:45 GMT

Hi All

I'm trying to create a report so show "Select Excluded" ie Dark Grey in the filter with the tick next to the value as a result of using Select Possible/ Select Excluded

I've created this measure

Count({1<[Requirement Part Id]=E([Requirement Part Id]),[Requirement Work Order Base Id]>}Distinct[Requirement Work Order Base Id]) which shows the light grey values

But its the dark grey with the ticks (In Qlik terminology, "Select Excluded") that I'm after.

Any help would be greatly appreciated.

Thanks

Re: Set Analysis to report "Select Excluded"

Scotchy — Mon, 08 Jul 2024 23:58:59 GMT

Hi GavK,

Here is a refined approach to achieve the desired result:

Measure to Count "Select Excluded" Values

Count({1<[Requirement Part Id]=E({1<[Requirement Part Id]=P([Requirement Part Id])>}), [Requirement Work Order Base Id]>} DISTINCT [Requirement Work Order Base Id])

Explanation

{1<[Requirement Part Id]=E(...)}>: This part uses the E() function to exclude selected values of [Requirement Part Id].
{1<[Requirement Part Id]=P([Requirement Part Id])>}: This part uses the P() function to include only the possible values of [Requirement Part Id].
Combining E() and P(): The combination ensures you are targeting values that are excluded but would be possible if the current selections were cleared, thus reflecting the "Select Excluded" state.

Example

Assume you have a dataset with [Requirement Part Id] and [Requirement Work Order Base Id]. This measure will count the distinct [Requirement Work Order Base Id] where [Requirement Part Id] is in the "Select Excluded" state (dark grey with ticks).

Usage