Qlik Community

New to Qlik Sense

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

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
mansoorsheraz
Contributor III
Contributor III

Display Parent Value for Child

Hi,

I have ran into an issue where I want to display the Parent's parameter value as default value for every child that is missing its own value. Here is the table showing my problem:

mansoorsheraz_0-1640287089911.png

So in the ID STMT column for Row 1 for the child "Chicago Department of Aviation, Illinois" I want to have "cityofchicago.org_cafr_2019" displayed.

Similarly for  "City of Chicago Department of Transportation, Illinois" in Row 4 , I again want to display "cityofchicago.org_cafr_2019" in the ID STMT column

I couldnt find any alternative to the LookUp function on the Charts. Can someone help me with this ?

Regards.

Labels (5)
3 Replies
mansoorsheraz
Contributor III
Contributor III
Author

Can anyone help me here ?

AshutoshBhumkar
Partner
Partner

Hello,

You can create a mapping table with Name Child and ID STMT. You will have 'City Of Chicago, Illinois' wise cityofchicago.org_cafr_2019 value

And lookup the value with Name Parent whenever the value in ID STMT is null (or length is 0).

Hope this helps.

 

Thanks,
Ashutosh

mansoorsheraz
Contributor III
Contributor III
Author

Didn't work as ID STMT is coming from another table. I tried using mapping and applymap.