topic Re: Need Help - For dynamically changing color of text on right-side of bars in QlikView

Need Help - For dynamically changing color of text on right-side of bars

neetu_singh — Thu, 19 Nov 2015 06:34:58 GMT

Dear All,

Actually I need dynamically changing color of text on right-side of bar charts(highlighted below) for negative (RED) & Positive (GREEN) numbers but it is not working due to second dimension

Please help.

Re: Need Help - For dynamically changing color of text on right-side of bars

arulsettu — Thu, 19 Nov 2015 06:40:03 GMT

post sample qvw of this chart

Re: Need Help - For dynamically changing color of text on right-side of bars

Gysbert_Wassenaar — Thu, 19 Nov 2015 06:46:51 GMT

You can use the Text Color setting of the expression:

Re: Need Help - For dynamically changing color of text on right-side of bars

neetu_singh — Thu, 19 Nov 2015 07:21:44 GMT

Yeah am doing the same but in my application we are using 2 dimension so because of second dimension it is not changing.

Re: Need Help - For dynamically changing color of text on right-side of bars

nagarjuna_kotha — Thu, 19 Nov 2015 07:41:07 GMT

PFA....

Re: Need Help - For dynamically changing color of text on right-side of bars

nagarjuna_kotha — Thu, 19 Nov 2015 07:49:28 GMT

Hi neetu,

I want to know one thing in your chart.

How you did Both negative and Positive values on same line.

Can u tell the procedure.

Regards,

Nagarjuna

Re: Need Help - For dynamically changing color of text on right-side of bars

Mark_Little — Thu, 19 Nov 2015 08:21:14 GMT

Hi,

Follow gwassenaar instructions, but in your expression just have the expression you want to impact the colour. So the one in the brackets.

Mark

Re: Need Help - For dynamically changing color of text on right-side of bars

neetu_singh — Thu, 19 Nov 2015 09:39:32 GMT

Text color property is not working in my scenario. I'm taking this value as an text not in bar presentation, please chk the attached image.

Re: Need Help - For dynamically changing color of text on right-side of bars

nagarjuna_kotha — Thu, 19 Nov 2015 10:04:37 GMT

Check this ,I tried in Text Box.To check this.Sect negative value in list box and the color in Text Box.

Reagrds,

Nagarjuna

Re: Need Help - For dynamically changing color of text on right-side of bars

neetu_singh — Thu, 19 Nov 2015 11:22:23 GMT

The scenario is am using this expression as a text nd bar is invisible. this is the reason that color is not changing. can you please share if there is any work around for the same.

Re: Need Help - For dynamically changing color of text on right-side of bars

Mark_Little — Thu, 19 Nov 2015 11:46:38 GMT

Hi,

I have set up what i think you have and it works fine for me. Check below and make sure I am following collecting.

So invisible bar graph.

Then under the test colour of the invisible bar graph change the text colour expression

Above is just my test.

Results

Mark

Re: Need Help - For dynamically changing color of text on right-side of bars

neetu_singh — Thu, 19 Nov 2015 12:16:07 GMT

Hey Mark,

Can you please tri in the attached app. May be you understand what I need to achieve.

Re: Need Help - For dynamically changing color of text on right-side of bars

Mark_Little — Thu, 19 Nov 2015 12:24:56 GMT

I will take a look.

Re: Need Help - For dynamically changing color of text on right-side of bars

Mark_Little — Thu, 19 Nov 2015 13:00:51 GMT

Hi,

You certainly found a nice one there, I can't even get the colour to change regardless of an if statement. If i find anything I let you know. But I am starting to thinking it won't be possible.

Mark

Re: Need Help - For dynamically changing color of text on right-side of bars

Thu, 19 Nov 2015 16:45:42 GMT

Neetu,

You should format 'Non - Commissionable 1'. Please see attached qvw.

Hope it help.

Thanks.

Re: Need Help - For dynamically changing color of text on right-side of bars

neetu_singh — Fri, 20 Nov 2015 07:03:21 GMT

Thank you so much....