Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

bhaveshp90
Contributor III

How to resolve this ?

Hello,

I have a table as shown below:  

 

1.PNGMy goal is to get the Schedule flag from "FACT Schedule" Tab as highlighted in yellow below;

 

2.PNG

 

 

 

 

 

 

 

 

 

I tried all ways to link them in the script (data model) when I select [New_Area] field the [SCH Schedule Flag] data is not responding as shown below (I think because [New_Area] & [SCH Task Discipline] is not connected)

Capture.PNG

 

 

 

 

 

 

 

 

 

 

 

My desired output should be like this:

when I select "MECHANICAL ENG" in [New_Area]

 

12.PNG

when I select "SOFTWARE ENG" in [New_Area]


13.PNG

 

 

when I select "CONTROLS ENG" in [New_Area]

14.PNG

 

 

 

Sorry for the long post,  I tried all the ways and checked with all my sources but couldn't able to get the desired output.

Could anyone help me? I sincerely thank you again for all your valuable time and help. Attached are the files for reference

 

thanks again

Bhavesh

 
  •  
Labels (1)