Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Indirect Dimension Selection in Qlik Sense

I have one requirement from client.

Resource Mapping and Department Details.

Exp : Each Employee has One Department and 5 Sub Departments 

Parent Department = Sub Department , Sub Department = Sub Department 1 And Sub Department 1 =Sub Department 2.

Requirement : "If One Employee Selected then All Related Departments get selected".

Please Suggest

 

5 Replies
Highlighted
Master II
Master II

Re: Indirect Dimension Selection in Qlik Sense

Please explain with some data or sample app please.

Learning never stops.
Highlighted
Contributor III
Contributor III

Re: Indirect Dimension Selection in Qlik Sense

Thank you Pradosh,

Sample Data

IdName DepSub1Sub2Sub3Sub4
1DilipA1A2A3A4A5
2JacksonA2A3A4A5 
3LiamA2A3A4A5 
4NoahA3A4A5  
5AidenA3A4A5  
6CadenA3A4A5  

 

If Name Jackson is Selected then Related Dep should select - Noah,Aiden & Caden 

Highlighted
Master II
Master II

Re: Indirect Dimension Selection in Qlik Sense

Dept has valye A1 TO A5 , so how the anmes would be selected in the department. I am sorry i am not getting the requirement.

 

Thanks

Pradosh

Learning never stops.
Highlighted
Contributor III
Contributor III

Re: Indirect Dimension Selection in Qlik Sense

Dear Pradosh,
If Name Jackson is Selected then A3,A4 & A5 Should Select.

Let me know if any clarifications
Highlighted
Contributor III
Contributor III

Re: Indirect Dimension Selection in Qlik Sense

Dear @swuehl  , @sunny_talwar  please suggest