How can I ignore all but one choice made by the user in a set analysis?

[Mr_small_t]

Hi

I Have writtten the set analysis below, and it works fine. As you can see i have used "1" as the set identifier. I choose 1 as identifier because the users might have done several choices and I want to ignore them. But now I do not want to ignore the choice the user has done for "Grlsoker_Klasordn_Grlhode_GRLID", only all the other choices made by the user.

In other words:

I want to ignore all the choices made by the user except "Grlsoker_Klasordn_Grlhode_GRLID". How can  i do that?

Set analysis:

=count(DISTINCT{1<
Grlsoker_Klasordn_Grlhode_GRLID = {'20180302Søker'},
Grlsoker_SKOLENR={">15000 <16000"},
Grlsoker_ONSKENR={1},
Grlsoker_SOKSTAT={'B', 'C', 'D', 'G', 'U'},
Grlsoker_RETT={'U'}
>} Grlsoker_FNR)

Regards

Torbjørn

[m_woolf]

=count(DISTINCT{1<
Grlsoker_Klasordn_Grlhode_GRLID = ,
Grlsoker_SKOLENR={">15000 <16000"},
Grlsoker_ONSKENR={1},
Grlsoker_SOKSTAT={'B', 'C', 'D', 'G', 'U'},
Grlsoker_RETT={'U'}
>} Grlsoker_FNR)

[vishsaggi · Accepted solution]

May be this?

=count(DISTINCT{1<
Grlsoker_Klasordn_Grlhode_GRLID = P(Grlsoker_Klasordn_Grlhode_GRLID),
Grlsoker_SKOLENR={">15000 <16000"},
Grlsoker_ONSKENR={1},
Grlsoker_SOKSTAT={'B', 'C', 'D', 'G', 'U'},
Grlsoker_RETT={'U'}
>} Grlsoker_FNR)

[Mr_small_t]

Hi Mwoolf, 

thanks for swift reply, but it does not seem to work. Should it be any tokens, etc.?

Regards,

Torbjørn

[Mr_small_t]

Hi

thanks for your reply Vishaggi! Perfect!

Regards, 
Torbjørn

[sunny_talwar]

If you want only direct selection to impact you can try this

=count(DISTINCT{1<
Grlsoker_Klasordn_Grlhode_GRLID = $::Grlsoker_Klasordn_Grlhode_GRLID,
Grlsoker_SKOLENR={">15000 <16000"},
Grlsoker_ONSKENR={1},
Grlsoker_SOKSTAT={'B', 'C', 'D', 'G', 'U'},
Grlsoker_RETT={'U'}
>} Grlsoker_FNR)