Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
tauceef
Partner
Partner

How to display only the associated values with respect to only selected values

Hi All,

We have a requirement where we need to show one table with data associated with all filter values applied.

Data sample:

Test:
LOAD * INLINE [
Patient, Symptoms
A, Cough
A, Fever
A, Cold
C, Cough
C, Cold
D, Cold
E, Cough
F, Fever
];

we will have filter for Symptoms and one table with Patient.

So when we apply filter for "Fever" only Patient F should display

when we select "Cough & Cold" Only Patient C should display

likewise if we select "Cold" only Patient D should display.

Any help would be great.

Regards, Tauceef

1 Solution

Accepted Solutions
Taoufiq_Zarra

@tauceef  may be like this :

in load script:

Test:
LOAD * INLINE [
Patient, Symptoms
A, Cough
A, Cough
A, Fever
A, Cold
C, Cough
C, Cold
D, Cold
E, Cough
F, Fever
];
left join load Patient,concat(distinct Symptoms,', ') as conatSymptoms resident Test group by Patient;

and then create table

dimension: Patient

measure:

if(GetFieldSelections(Symptoms)=conatSymptoms,GetFieldSelections(Symptoms))

and uncheck inclure null value

output:

Taoufiq_Zarra_0-1642069080620.png

Taoufiq_Zarra_1-1642069222957.png

 

Taoufiq_Zarra_2-1642069261930.png

 

 

 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@tauceef  may be like this :

in load script:

Test:
LOAD * INLINE [
Patient, Symptoms
A, Cough
A, Cough
A, Fever
A, Cold
C, Cough
C, Cold
D, Cold
E, Cough
F, Fever
];
left join load Patient,concat(distinct Symptoms,', ') as conatSymptoms resident Test group by Patient;

and then create table

dimension: Patient

measure:

if(GetFieldSelections(Symptoms)=conatSymptoms,GetFieldSelections(Symptoms))

and uncheck inclure null value

output:

Taoufiq_Zarra_0-1642069080620.png

Taoufiq_Zarra_1-1642069222957.png

 

Taoufiq_Zarra_2-1642069261930.png

 

 

 

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
tauceef
Partner
Partner
Author

Awesome you are, it works. Thanks for your help 🙂.

Only thing is, instead of Measure we have to take 2nd column as Dimension only.