Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmanvepuri
Creator
Creator

Reg: Color coding in Straight Table based on condition for complete row/data

Hi All,

I have the scenario like this.  Based on the data: the color of the complete row to show like this.

KN_VAL is a measure and the coding as below.

KN_VALCOLOR code
<1.0RED
1.0<X<1.4YELLOW
1.4<X<1.8BLUE
1.8<X<5.0GREEN
5.0<X<999ORANGE

OUTPUT should be like this.

screenshot.749.jpg

can any one help me how to achieve this.

Thanks a lot.

Lakshmana

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

HI,

Try like this

If(KN_VAL<1.0, Red(),

If(KN_VAL>=1.0 and KN_VAL<1.4, Yellow(),

If(KN_VAL>=1.4 and KN_VAL<1.8, LightBlue(),I

f(KN_VAL>=1.7 and KN_VAL<5.0, LightGreen(),

RGB(265,165,0)))))


Note: You have to give this Color expression for all the dimensions and expressions.


Regards,

Jagan.

View solution in original post

5 Replies
jagan
Luminary Alumni
Luminary Alumni

HI,

Try like this

If(KN_VAL<1.0, Red(),

If(KN_VAL>=1.0 and KN_VAL<1.4, Yellow(),

If(KN_VAL>=1.4 and KN_VAL<1.8, LightBlue(),I

f(KN_VAL>=1.7 and KN_VAL<5.0, LightGreen(),

RGB(265,165,0)))))


Note: You have to give this Color expression for all the dimensions and expressions.


Regards,

Jagan.

lakshmanvepuri
Creator
Creator
Author

Hi jagan,

I implemented the above way only, I would like to check Is there any alternative way to with out giving the expression to all the dimensions.

Thanks

Lakshmana

Chanty4u
MVP
MVP

u can use custom format cell.. 

jagan
Luminary Alumni
Luminary Alumni

Hi Lakshman,

There is no other way if you want to have 5 different color codes, this is the best method and it works in all charts.

You can use Visual Clues option but you can give only two colors and available only for Pivot and Straight tables.

Regards,

Jagan.

lakshmanvepuri
Creator
Creator
Author

Thank you very much jagan‌ for giving the solution.