topic Re: row color based on total in QlikView

row color based on total

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

Hi,

Based on total we need to color the entire row.

Like if total is <10 then i need to show the entire row as red.Just like below and only for the dimension category.

Attached is the sample data.

Re: row color based on total

bramkn — Wed, 07 Mar 2018 07:12:27 GMT

Calculate the total you want in a variable for easy use. And then just put in the variablename < 10. I think this is where you don't use the $() arround the variable.

Edit: Sorry its early, this won't help you. What row do you want to color? any row? based on the total of those marked columns? Don't understand what you want really. Can be me on this early morning.

Re: row color based on total

nareshthavidishetty — Wed, 07 Mar 2018 07:21:28 GMT

Hi,

If sales is < 10 i need to color the entore row as red else white.

Thanks..

Re: row color based on total

bramkn — Wed, 07 Mar 2018 07:25:55 GMT

What row? and what total?

You mean that for example 2014 row <10 then have it red?

Re: row color based on total

ruchirasamant — Wed, 07 Mar 2018 07:40:58 GMT

Hi,

Try this

Go to your expression --> expand your expression --> in background color add this condition

If((sales<10),RGB(255,100,100),))

Thanks,

Ruchira

Re: row color based on total

vangurideepu — Thu, 08 Mar 2018 07:49:00 GMT

If your using the pivot or straight table, there is an two ways to change columns color

1. using condition and (for this you follow the above steps)

2 using Visual cues ( for this you can select any expression and set the upper and lower values then select the back ground color whatever you want as change the text color as you want)

Re: row color based on total

kristof_j — Thu, 08 Mar 2018 08:24:44 GMT

And if you add this expression in the background color?

if(sum(total<Product> sales) < 10, LightRed())

and disable 'Suppress Zero-Values' in the Presentation tab. Now you'll get a 0 and not a -.

This is my result

And play a bit with the color like 'lightred(50)' or something 🙂 that's up to you.

Re: row color based on total

krishna20 — Thu, 08 Mar 2018 09:47:34 GMT

Hi Naresh,

try this in expression's background color

=if(rowno()=0 or isNull(rowno()) >10

,rgb(255,255,0)

,rgb(255,255,255)

)