How to make "-" fields clickable

[#1]

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!

[sunny_talwar · Accepted solution]

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;

[rajan_07kumar]

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. !