topic Re: Funnel Chart Font in QlikView

Funnel Chart Font

Thu, 21 Jun 2012 14:37:12 GMT

Hello-

Can the "Value on Data Points" font color be changed? I can get the format of the font to change, not the color though.

Re: Funnel Chart Font

Miguel_Angel_Baeyens — Fri, 22 Jun 2012 06:55:23 GMT

Hi,

Yes, you can do that going to the object properties, Expressions tab, and expanding the expression which value you want to change using the [+] button at the left of the expression.

There you have a "Text Color" where you can set any valid expression that returns a color code, for example, if you want the value to be red if the result of the expression is less than zero, the following will work:

If(Sum(Sales) < 0, RGB(255, 0, 0))

Hope that helps.

Miguel

Re: Funnel Chart Font

Anonymous — Fri, 22 Jun 2012 07:00:48 GMT

miguel is rite...

n another way is jst change give the rgb color code as text color on the nided expression.

i mean is

expand the Plus sign of expression n choose text color.

Re: Funnel Chart Font

Fri, 22 Jun 2012 13:19:05 GMT

Neither of these options changed the color of the font. Thank you for your reply though!

Re: Funnel Chart Font

Miguel_Angel_Baeyens — Fri, 22 Jun 2012 15:08:29 GMT

Hi Tina,

I have been playing around a bit and you are right. For some reason what works in the same object if you change from funnel chart to say block chart or bar chart, where the values are correctly displayed in colors, does not work in funnels. I've opened a case in Support so they can tell us if we are doing something wrong, or this is the expected behavior, or a bug.

I'll keep you posted and thank you very much Tina for raising the question!

Miguel

Re: Funnel Chart Font

Fri, 22 Jun 2012 18:03:55 GMT

Thank you so much for opening a case in Support. I look forward to an answer.

Have a great day!

Re: Funnel Chart Font

Fri, 17 Aug 2012 21:23:46 GMT

Hello Miguel - I too thank you for opening this case with Support. Have they provided any updates?

Thanks very much,

Chris

Re: Funnel Chart Font

Tue, 11 Jun 2013 14:50:23 GMT

Hi,

Any luck with the font colors on Funnel charts?

Thanks,

Izabela