Discussion board where members can get started with Qlik Sense.
in my work i have a few charts like this:
How can I make the grey part choosable?
For better understanding, this is what the table looks like:
Table 1, Objects:
Table 2, Tags:
The measure is just a count of the object names.
I think what I need is a formula for the data editor, that does this:
IF the Object has no tag THEN give it the tag "-"
How do I put that into qlik syntax in in which part of the editor do I insert that?
I would really appreciate your help!
Go to Solution.
May be something like this:
LOAD * Inline [
Object 1, Local
Object 2, Local
Object 3, Global
LOAD ObjectName as ObjectName1
LOAD ObjectName1 as ObjectName,
'NULL' as Tag
Where not Exists(ObjectName, ObjectName1);
DROP Table Table1;
I am assuming you left joined table 1 with table 2. You can not further select into "-" unless you have a record for object 4 in table two.
An alternate way is the following:
assign your object4 a dummy value in the script, like I have attached. Please go through the script. !