
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Supriya,
You can achieve like this.
PFA qvw for the reference.
Thanks,
Ganesh


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi all,
Only considering the use Qlik Sense the expression will be in colors expression measures of Qlik Sense.
Regards,
Andrey

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
thanks for your idea let me try this. can you put code over here, beacuse i am using qliksense.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
