topic colour coding in straight table in QlikView

colour coding in straight table

Wed, 25 Mar 2015 10:56:14 GMT

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 .

Re: colour coding in straight table

Gabriel — Wed, 25 Mar 2015 11:06:23 GMT

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

Re: colour coding in straight table

Wed, 25 Mar 2015 11:15:01 GMT

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

Re: colour coding in straight table

awhitfield — Wed, 25 Mar 2015 11:25:06 GMT

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

Re: colour coding in straight table

Wed, 25 Mar 2015 11:37:25 GMT

Hi Andrew,

Thanks for reply.i need like this.please help me

Re: colour coding in straight table

sunilkumarqv — Wed, 25 Mar 2015 11:39:15 GMT

give this below exp in Dimension FIELD1

IF(Field1>Field2,Red())

Re: colour coding in straight table

Gabriel — Wed, 25 Mar 2015 12:11:10 GMT

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