topic Re: block chart in QlikView

block chart

NavinReddy — Tue, 26 Aug 2014 18:28:37 GMT

Dear Experts ,

I have an Issue I am creating block chart,here i have some negative values

How to show in block chart negative values in red color

Please find the image

Thanks In Advance

Niranjan

JonnyPoole — Tue, 26 Aug 2014 18:41:55 GMT

little confused. if you have both positive and negative values in the chart you will get an error: "positive and negative values in the chart'.

your screenshot shows a positive number.

also are you trying to change the color of the block or the label/number that sits in the block ?

please elaborate a bit more on your need .

israrkhan — Tue, 26 Aug 2014 19:42:47 GMT

Have you tried, in expression>> Text Color,, type expression like below.

if(sum(sale) < 0,Red(), Black())

NavinReddy — Tue, 26 Aug 2014 19:47:59 GMT

Hi,

i tried but its changing full text color ,but i want to change the only value color

Please find the image

Regards,

Niranjan

NavinReddy — Tue, 26 Aug 2014 19:50:22 GMT

Hi Jon,

Chart showing like positive only because if its negative block chart wont work

But in chart negative values also there ,

Those values i want to show in Red Color

please find the image

Regards,

Niranjan