This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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:
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 ?
Can anyone help me here ?
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.
Didn't work as ID STMT is coming from another table. I tried using mapping and applymap.