Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator II

Changing text color in Table

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?

4 Replies
ganeshreddy
Creator III
Creator III

Hi Supriya,

You can achieve like this.

Capture5555.PNG

PFA qvw for the reference.

Thanks,

Ganesh

ahaahaaha
Partner - Master
Partner - Master

Hi all,

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

Regards,

Andrey

berryandcherry6
Creator II
Creator II
Author

Hi,

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

ahaahaaha
Partner - Master
Partner - Master

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