Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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:
Object Name |
---|
Object 1 |
Object 2 |
Object 3 |
Object 4 |
Table 2, Tags:
Object Name | Tag |
---|---|
Object 1 | Local |
Object 2 | Local |
Object 3 | Global |
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!
May be something like this:
Table2:
LOAD * Inline [
ObjectName, Tag
Object 1, Local
Object 2, Local
Object 3, Global
];
Table1:
LOAD ObjectName as ObjectName1
Inline [
ObjectName
Object 1
Object 2
Object 3
Object 4
];
Concatenate(Table2)
LOAD ObjectName1 as ObjectName,
'NULL' as Tag
Resident Table1
Where not Exists(ObjectName, ObjectName1);
DROP Table Table1;
May be something like this:
Table2:
LOAD * Inline [
ObjectName, Tag
Object 1, Local
Object 2, Local
Object 3, Global
];
Table1:
LOAD ObjectName as ObjectName1
Inline [
ObjectName
Object 1
Object 2
Object 3
Object 4
];
Concatenate(Table2)
LOAD ObjectName1 as ObjectName,
'NULL' as Tag
Resident Table1
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. !