This content has been marked as final. Show 9 replies
I have two tables - Code1 and Code2.
I have made a Filter Pane with Code1 as dimension and I want to show only higlighted blue codes from table Code1 and Code2 in the filter pane for Code1.
Whenever code XX appears in table Code1 it shall be replaced with Code2, but not all - only specific codes are to be shown in Code1.
I have managed to get XX replaced in Code1 with (not sure if this is the correct way to do it, but the codes were replaced).
if(code1='XX', [code2], code1)
But from here I am not able to find the right expression as I am not too familiar with expressions or set analyse.
Wanted result in Filter Pane for Code1
I am using Qlik Sense Server, v3.x