Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
gradiske
New Contributor III

how to paint entire row based on last month value?

Guys, i'm having trouble to do something i think its simple but i can't reach the solution

I have this table

Sem título.png

The red ones are based on if(Realizado>Orçado) then Red.

What i need to do is, paint the entire row in red if the last month of the selections, in this case, december, if the last month is red, the entire row should be red.

Any ideas?

6 Replies
MVP & Luminary
MVP & Luminary

Re: how to paint entire row based on last month value?

You can apply the same color condition to all the expressions. Click on the + in front of the expression, choose Background Color and enter your color expression. You won't be apply to apply it to your first dimension since that cell spans lots of rows.


talk is cheap, supply exceeds demand
gradiske
New Contributor III

Re: how to paint entire row based on last month value?

The same color condition is already set in all expressions, the problem is, if one month not correponds to the logic (Realizado>Orçado) it will not paint in red. I want to ignore the currentmonth and only consider the last possible one.

HirisH_V7
Honored Contributor

Re: how to paint entire row based on last month value?

Hi ,

In Your second Expression-> Back Gorund Colour ->

=If(Realizado>Orçado,LightRed())



Mention Your complete Expression at Both Fields

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
gradiske
New Contributor III

Re: how to paint entire row based on last month value?

=If(Realizado>Orçado,rgb(255,94,94))

I've tried this too much that i posted the wrong print, heres what it looks like.

Sem título2.png

If you look at A-2 or A-3, for example, in December(Competencia dez/2015) Realizado>Orçado=False, so, the entire row should remain blue(the default color).

X-6, X-7 and A-1 are entire filled with red because every single month returns Realizado>Orçado=True. I want to paint everything based on the last possible month only.

I know that =If(Realizado>Orçado,rgb(255,94,94)) never will achieve that requirement, but i've tried all sort of set analysis possible.

The expressions at Realizado and Orçado are simple: Sum(field)

HirisH_V7
Honored Contributor

Re: how to paint entire row based on last month value?

Hi,


Do you want to red line particularly for 7th Line or what ?

HirisH
“Aspire to Inspire before we Expire!”
gradiske
New Contributor III

Re: how to paint entire row based on last month value?

Hi,

I want red line on the rows that the last month(competencia) returns True to Realizado>Orçado.

In the picture, we have Oct, Nov and Dec. It doesnt matter if Oct and Nov returns False, if the value at Dec returns True, all the values in the row should be painted red.