Changing text color in Table

[berryandcherry6]

Hi,

i have table as shown below

Metrics      Count

Parlegi      123(+23)

Orea          34(-2)

Dimension:Metrics

Expression:

if(Metrics='Parlegi',($(Parlegi_count)&'('&$(Parlegi_Invitations)&')'),

if(Metrics='Orea',$(Orea_count)&'('&$(Orea_Invitations)&')'))

For above i need to change color according to -ve Red color and +ve Green color. Like below.

Metrics      Count

Parlegi      123(+23)

Orea          34(-2)

How could i do it?

[ganeshreddy]

Hi Supriya,

You can achieve like this.

PFA qvw for the reference.

Thanks,

Ganesh

[ahaahaaha]

Hi all,

Only considering the use Qlik Sense the expression will be in colors expression measures of Qlik Sense.

Regards,

Andrey

[berryandcherry6]

Hi,

thanks for your idea let me try this. can you put code over here, beacuse i am using qliksense.

[ahaahaaha]

Hi,

If the source file xlsx, Ganesh shown above is suitable (ie for example, 123 and (23) in different fields) ,  the color expression might look like this

if(PurgeChar(var,'()')>0,green(),red())

An example of the attached file.

Regards,

Andrey