Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

perumal_41
Valued Contributor II

changing text and background color

Hi ,

I am using simple table extension .My requirement want change row  text and background color based condition.

how can achieve it . please help me on this

eg

 

Name

Mark

Pass

Bala

25

NO

Arun

50

YES

Perumal

39

YES

 

Thanks in advance

9 Replies
vikasmahajan
Honored Contributor III

Re: changing text and background color

Not applicable

Re: changing text and background color

Hi,

There are text boxes for 'Background colour expression' and 'Text color expression' in the Data tab.

sample.png

Regards,

Rohan

vikasmahajan
Honored Contributor III

Re: changing text and background color

Goto Expression

expand + sign for expression

and add below expression in background colour.

if( Mark  <=25  ,red(),

if(Mark   >25 ,green()))

hTH

vikas

perumal_41
Valued Contributor II

Re: changing text and background color

Hi Vikas,

Thanks for your response.

I know this can achievable in Qlikview  ,but not able achieve in  qlik sense

perumal_41
Valued Contributor II

Re: changing text and background color

Hi Rohan,

Thanks for your reply.

This will working for only expression level ,but my requirement want  apply color change in Dimension level also.

vikasmahajan
Honored Contributor III

Re: changing  text and background color

try to put this formula with back ground color expression text box in sense

Vikas

vikasmahajan
Honored Contributor III

Re: changing text and background color

Not applicable

Re: changing text and background color

Hi,

I don't think that is possible with the table in Qliksense. You will have to use extensions for that.

Check this extension out.

http://branch.qlik.com/#/project/56728f52d1e497241ae6979d

Regards,

Rohan

perumal_41
Valued Contributor II

Re: changing text and background color

Hi Vikas,

This will working for only measure level ,but  want to  apply color change in Dimension level also.

Community Browser