topic Re: Visual Effects Tab in QlikView

Visual Effects Tab

npadilla73 — Tue, 07 Jul 2015 16:07:38 GMT

Hello Community,

I have a pivot table with my production of the month, but I need identifying if my shift production reached their goal in the day. So, in the Visual Effects Tab, in the option upper, I write down the field "Goal Production" , and do the same in the lower option. But it does not work properly, because my expression remains in black color, but if I select only one ITEM, the funtion works well.

Can someone tell me what I am doing wrong?

Thanks

I attached an example.

Re: Visual Effects Tab

stigchel — Tue, 07 Jul 2015 16:15:36 GMT

Instead of using the visual cues, use the background color option of the expression (click on the plus sign in front). There use

=if(Cantidad>[Goal Production],Green(),Red())

Re: Visual Effects Tab

npadilla73 — Tue, 07 Jul 2015 16:40:32 GMT

Thanks, that's exactly what I need.

Re: Visual Effects Tab

stigchel — Tue, 07 Jul 2015 16:51:58 GMT

You're welcome. You may want to add a rowno and/or secondarydimensionality condition to skip the totals from coloring, so

=IF(SecondaryDimensionality()>0,

if(Rowno()>0,if(Cantidad>[Goal Production],Green(),Red()))

)

Also if this has answered your question, could you mark the answer correct. It will close the thread helping others to find correct answers and let other contributing members know this requires no more attention

Re: Visual Effects Tab

npadilla73 — Tue, 07 Jul 2015 16:56:17 GMT

This sentence is better, thanks again.