Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Mr_small_t
Contributor III
Contributor III

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
Champion III
Champion III

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)

View solution in original post

5 Replies
m_woolf
Master II
Master II

=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
Champion III
Champion III

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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)