topic colors in QlikView

colors

Mon, 12 Oct 2009 17:28:45 GMT

Hi,

I have to background colors for the actual Qty in pivot chart like this->

1.if actual qty >budget Qty by >=80% greencolor

2.if actual qty >budget Qty by <=50% red color

3.Rest in orange color.

I dont want to add a seperate % measure.Rather i have to show colors in actual Qty measure row based on the above condition.

I need to implement this using visual clues.

At present i am getting only one color.

PLease help.

Urgent.

Thanks in advance.

kji — Mon, 12 Oct 2009 18:19:05 GMT

Dont use visual cues for this, rather us Background Color Expression like:

if(qty/[budget Qty] > 0.8, Green(),if(qty/[budget Qty] < 0.5,Red(), Orange()))

Mon, 12 Oct 2009 18:30:45 GMT

Thank you.

But if i use the exprssions for background color the measure name is also taking the color of the first value cell.

How do i resolve this.

I want colors only in the text field and the measure names or labels should not take the colors.

Please help.

Thanks in advance.