Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Mr_small_t
New Contributor

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

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

Labels (1)
1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

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

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)

5 Replies
mwoolf
Honored Contributor II

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

=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
Esteemed Contributor III

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

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
New Contributor

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

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
New Contributor

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

Hi

thanks for your reply Vishaggi! Perfect!

 

Regards, 
Torbjørn

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

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)