topic Re: changing text and background color in Integration, Extension & APIs

changing text and background color

perumal_41 — Wed, 09 Mar 2016 05:39:34 GMT

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

Name	Mark	Pass
Bala	25	NO
Arun	50	YES
Perumal	39	YES

Thanks in advance

Re: changing text and background color

vikasmahajan — Wed, 09 Mar 2016 05:47:16 GMT

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

HTH

Vikas

Re: changing text and background color

Wed, 09 Mar 2016 05:49:36 GMT

Hi,

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

Regards,

Rohan

Re: changing text and background color

vikasmahajan — Wed, 09 Mar 2016 05:50:48 GMT

Goto Expression

expand + sign for expression

and add below expression in background colour.

if( Mark <=25 ,red(),

if(Mark >25 ,green()))

hTH

vikas

Re: changing text and background color

perumal_41 — Wed, 09 Mar 2016 09:56:47 GMT

Hi Vikas,

Thanks for your response.

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

Re: changing text and background color

perumal_41 — Wed, 09 Mar 2016 09:58:30 GMT

Hi Rohan,

Thanks for your reply.

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

Re: changing text and background color

vikasmahajan — Wed, 09 Mar 2016 10:21:12 GMT

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

Vikas

Re: changing text and background color

vikasmahajan — Wed, 09 Mar 2016 10:23:00 GMT

see this link

Qlik sense straight table measure color expression

Vikas

Re: changing text and background color

Wed, 09 Mar 2016 10:23:42 GMT

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

Re: changing text and background color

perumal_41 — Wed, 09 Mar 2016 11:48:17 GMT

Hi Vikas,

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