Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to make "-" fields clickable

Hi,

in my work i have a few charts like this:

example.PNG

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 NameTag
Object 1Local
Object 2Local
Object 3Global

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!

1 Solution

Accepted Solutions
MVP
MVP

Re: How to make "-" fields clickable

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;

2 Replies
MVP
MVP

Re: How to make "-" fields clickable

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
New Contributor II

Re: How to make "-" fields clickable

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