topic Conditional back ground color in QlikView

Conditional back ground color

Sat, 12 Sep 2009 22:24:01 GMT

Hi All,

I want to change the back ground colour of my chart table according to the value.

For example for Profit < 100 and > 85 ----Yellow.

Profit <85 and > 50 ---------------orange

Profir< 50 --------------------Red

And when the Profit is more than 100 but less that 500 -------White

Profit > 500 ---------------Green with alert.

As of now i can set for three conditions.

Could anyone please help me to get this in QV?

Thanks & Regards,

Mahasweta

Conditional back ground color

Sat, 12 Sep 2009 23:11:40 GMT

If it's a Gauge Chart you can add any number of segments.

And in case of Pivot Table and straight table, maximum of 3 colors only you can set, i think.

Conditional back ground color

ipauldur — Sun, 13 Sep 2009 13:03:26 GMT

Hi,

Find the attached file..

Hope this will help.

Thanks,

Durai.

Conditional back ground color

Mon, 14 Sep 2009 13:00:11 GMT

Thanks a ton Durai.

Yes it worked as i want.

Best Regards,

Mahasweta

Conditional back ground color

Mon, 14 Sep 2009 18:32:54 GMT

Hi Durai,

One quick check please.

Here am getting the back ground color for the data. But am observing one thing here as the column name lable also getting the background color , which i dont want.

Means if i have more red back ground color then the column heading also getting the back ground color as red.

Could you please guide me how to remove the color for the column lable name.?

Thanks,

Mahasweta

Conditional back ground color

ipauldur — Mon, 14 Sep 2009 18:48:55 GMT

Hi,

If you use straight table instead of pivot, then back ground color will not come for column name.

I don't know ,how can we remove color on pivot table.

Thanks,

Durai.

Conditional back ground color

Mon, 14 Sep 2009 18:59:21 GMT

Can we get the same for Pivot table?

Thanks,

Mahasweta

Conditional back ground color

ipauldur — Tue, 15 Sep 2009 15:16:47 GMT

Hi,

If it's important to use only pivot and not minimizing the chart,then you can use text object with always top properties,white back ground, and keep the top of expression name.

But I don't think, this is not a perfect solution.

Regards,

Durai.

Conditional back ground color

Tue, 15 Sep 2009 17:08:55 GMT

If it's important to use only pivot and not minimizing the chart,then you can use text object with always top properties,white back ground, and keep the top of expression name.

But I don't think, this is not a perfect solution.

Could you please tell me where to implement?

(like use text object with top properties)

Thanks,

Mahasweta

Conditional back ground color

ipauldur — Tue, 15 Sep 2009 17:23:00 GMT

Hi,

Find the attached file.

Thanks.