changing text and background color

[perumal_41]

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

[vikasmahajan]

check this https://community.qlik.com/docs/DOC-8006

HTH

Vikas

[#3]

Hi,

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

Regards,

Rohan

[vikasmahajan]

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]

Hi Vikas,

Thanks for your response.

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

[perumal_41]

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]

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

Vikas

[vikasmahajan]

see this link

Qlik sense straight table measure color expression

Vikas

[#9]

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]

Hi Vikas,

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