Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
prahlad_infy
Creator II
Creator II

Help for Set expression to fetch count of possible indirectly selected value ?

Hello Everyone ,

For given data i need to find the count of employee  for each employee based on shared id .

id employee designation type
1 a ax t1
4 a ax t5
2 a bx t1
5 b bx t1
6 b bx t2
6 b bx t5
7 b bx t2
8 b bx t2
3 b cx t1
1 c cx t4
7 c cx t3
2 d dx t4
7 a ex  
9 f fx t2
3 e gx t6
4 g gx t1
5 g gx t5

 

Result of set expression 

employee id# various_id count of employee id sharing various_id various_id shared by 
a 4 1 , 2 , 4 , 7 5 a,b,c,d,g
b 5 3 , 5 , 6 , 7 , 8 4 a,b,c,e
c 2 1 , 7 4 a,b,c
d 1 2 2 a,d
e 1 3 ? ?
f 1 9 ? ?
g 2 4 , 5 ? ?
1 Solution

Accepted Solutions
MarcoWedel

Hi,

as you already thanked me, I kind of feel obliged to post an answer  😉

So one solution (although not using set expressions) might be:

 

QlikCommunity_Thread_t5_QlikView-App-Dev_Help-for-Set-expression-to-fetch-count-of-possible-indirectly_m-p_1852380_Pic1.PNG

QlikCommunity_Thread_t5_QlikView-App-Dev_Help-for-Set-expression-to-fetch-count-of-possible-indirectly_m-p_1852380_Pic2.PNG

table1:
LOAD id, 
     employee, 
     designation, 
     type
FROM [https://community.qlik.com/t5/QlikView-App-Dev/Help-for-Set-expression-to-fetch-count-of-possible-indirectly/m-p/1852380] (html, codepage is 1252, embedded labels, table is @1);

table2:
LOAD id,
     employee as employeeSharingIds
Resident table1;

 

hope this helps

Marco

View solution in original post

4 Replies
prahlad_infy
Creator II
Creator II
Author

@MarcoWedel 
Thank You

MarcoWedel

Hi,

as you already thanked me, I kind of feel obliged to post an answer  😉

So one solution (although not using set expressions) might be:

 

QlikCommunity_Thread_t5_QlikView-App-Dev_Help-for-Set-expression-to-fetch-count-of-possible-indirectly_m-p_1852380_Pic1.PNG

QlikCommunity_Thread_t5_QlikView-App-Dev_Help-for-Set-expression-to-fetch-count-of-possible-indirectly_m-p_1852380_Pic2.PNG

table1:
LOAD id, 
     employee, 
     designation, 
     type
FROM [https://community.qlik.com/t5/QlikView-App-Dev/Help-for-Set-expression-to-fetch-count-of-possible-indirectly/m-p/1852380] (html, codepage is 1252, embedded labels, table is @1);

table2:
LOAD id,
     employee as employeeSharingIds
Resident table1;

 

hope this helps

Marco

MarcoWedel

@prahlad_infy , if your question is answered, please close your thread by accepting a solution.

thanks

Marco

prahlad_infy
Creator II
Creator II
Author

Yeah Sure . Sorry for delay .