Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
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.

View solution in original post

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
Champion III
Champion III

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.