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

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

lakshmanvepuri — Wed, 25 Nov 2020 16:16:04 GMT

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.

OUTPUT should be like this.

can any one help me how to achieve this.

Thanks a lot.

Lakshmana

jagan — Wed, 09 Mar 2016 03:19:57 GMT

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 — Wed, 09 Mar 2016 03:25:10 GMT

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 — Wed, 09 Mar 2016 11:59:05 GMT

u can use custom format cell..

jagan — Thu, 10 Mar 2016 00:54:05 GMT

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 — Thu, 10 Mar 2016 01:47:29 GMT

Thank you very much jagan‌ for giving the solution.