If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I'm trying to figure out how to replace the '-' that comes for empty null values after joins. After joining two tables, my data looks like this:
ID Object_1 Object_2
1 - Apple
2 Orange Banana
3 Grapes -
I would like to replace all the '-' with 'Null' so that they can be searched using a filter pane.
Did you try the following script to replace '' with NULL ?
test:load ID,If(len(trim(Object_1))=0,'NULL',Object_1) as Object_1,If(len(trim(Object_2))=0,'NULL',Object_2) as Object_2;load * Inline [ID, Object_1, Object_21,,Apple2,Orange,Banana3,Grape,];