topic Re: value on Data Point only in total bar within bar chart in QlikView

value on Data Point only in total bar within bar chart

Tue, 04 Aug 2015 07:27:44 GMT

Hi QV Developers!,

I have problem connected with adding value on data point in bar chart in total bar:

I want to have % only in the last bar (total bar).

For changing color for total bar i used definition within background color something like that:

If(Dimensionality()=0,color(7))

I was trying to do the same with show value but it seems not possible in QV:

If(Dimensionality()=0,1,0).

Have you ever had similar problem to mine?

Please help me,

thank you in advance good people!

Best Regards,

Lukasz J.

Anonymous — Fri, 07 Aug 2015 12:00:24 GMT

Hi,

the answer is simple:

On your image you there are bars with gray color and total bar is black.

So you can write something like this in Text Color of Value on Data Point:

Anonymous — Fri, 07 Aug 2015 12:02:06 GMT

if(Dimensionality()=0,RGB(255,255,255),RGB(185,185,185))

dimensionality=0 is a total bar.

So font color is depends on bar color - simple

But it is only work around...maybe you have better idea.

Best Regards

Jacek Antek