Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

colour coding in straight table

hi guys,

I have an issue regarding with the colour coding to the text in straight table the requirement, in a expression field 1 is grater than field 2, then test values should be change like this .

screenshot.png

Tags (1)
6 Replies
Gabriel
Valued Contributor II

Re: colour coding in straight table

Hi,

So what you want to achieve is if Field1 is greater than Field2 then the background of field1 to be red? If that's correct then copy your expression from Expression atb (from test) click the + sign and copy the expression you have there. Now go to Dimensions tab click + sign for FIELD1 click Background Color and click on Edit then paste your copied expression there. Finally click Ok. That should be it

Here is your expression

if(FIELD1>FIELD2,RGB(300,0,0))

Hope this helps

Not applicable

Re: colour coding in straight table

Hi Gabriel,

thanks for reply i know that but requirement is i need just change color of field1. i'm getting 24/21 is in red i want 24 is in red and 21 should be black

example:     red            black

                     24     /     21

                    27      /     21

                    31     /     21

awhitfield
Esteemed Contributor

Re: colour coding in straight table

You code actually says if the value in field1 is greater than the value fin Filed2 then make the text colour of the value in TEST red!

That's what it's doing, you need to add the colour expression to the text colour property on the Filed1 dimension instead

Andy

Not applicable

Re: colour coding in straight table

Hi Andrew,

Thanks for reply.i need like this.please help mescreenshot.png

sunilkumarqv
Valued Contributor II

Re: colour coding in straight table

give this below exp in Dimension FIELD1

IF(Field1>Field2,Red())

Gabriel
Valued Contributor II

Re: colour coding in straight table

Hi,

Quick question.

Must you concatenate Field1 and Field2? Can you not leave it separate? This will make it easier to highlight whichever is greater between both field. And if you must concatenate both fields then here's my suggestion.

Have 1 more expression using

=if(FIELD1 > FIELD2, FIELD1 ,FIELD2)  // in the expression tab

Label it as Test2

Then in the Text Color (click + sign from Test2 ) and enter

=if(FIELD1 > FIELD2,RED())

Hope this make sense and helpful


Community Browser