Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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)

View solution in original post

Mr_small_t
Contributor III
Contributor III

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

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)