Qlik Sense - how to produce a straight table with "green red" indicator?

[jim_chan]

Hi there,

I know In QlikView, i definitely can create this kind of table using straight table, now, how can i achieve back the same thing  in Red color box" the green red indicator? how to do that?

Jim

[kumarnatarajan]

Hi Jim,

Right now there is no native indicator feature in qlik sense table, But couple of ways you can add the indicators. See the below example.

Ex1:

1. Value with Indicators

Using Expression, Text Color and Format you can archive this in measure column.

Expression :

Sum(FieldName)

Format :

Change Format to Custom and add the below format in "Format Pattern"

#,##0▲;-#,##0▼

Test Color:

Add condition like below mentioned

if(Sum(FieldName)<=0,Green(),rgb(255,0,0))

Ex2:

2. Only Indicators

Using Expression and Text Color you can archive this in measure column.

Expression :

if(Sum(FieldName)>=0,'▲','▼')

Test Color:

Add condition like below mentioned

if(Sum(FieldName)<=0,Green(),rgb(255,0,0))

[jim_chan]

Thanks, Kumar. I will try that.

Rgds,

Jim