Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bharathkamath28
Contributor III
Contributor III

concat or show all possible values

Hi All,

 

Can someone help me with the below scenario.

Input

bharathkamath28_0-1608033108004.png

expected output.

If a user selects on Name= A  or B or C or D, then it should show 

bharathkamath28_1-1608033200455.png

As Check = 10 is common on all ID.

If we select Name = E then

bharathkamath28_2-1608033313598.png

 

If the user selects  Name = F or G or H

bharathkamath28_3-1608033354367.png

As check= 11 is common across all.

 

Thanks,

 

 

Labels (1)
1 Reply
PriyankaShivhare
Creator II
Creator II

MapCheck:
Mapping Load
Check,
Concat( Name,',') as Name
group by Check;

Load *inline [
ID, Name, Check, Place
1 , A, 10, Blore
2 , B , 10, mum
3 , C , 10 , Blore
4 , D, 10, mum

];


Load *,
subfield(newName,',') as newName1;
Load *,
Applymap('MapCheck',Check,null()) as newName


inline [


ID, Name, Check, Place

1 , A, 10, Blore
2 , B , 10, mum
3 , C , 10 , Blore
4 , D, 10, mum

];

Take newName1 field as your filter