topic Re: Text Colour and Background colour in a Pivot Chart in QlikView

Text Colour and Background colour in a Pivot Chart

Anonymous — Thu, 14 Sep 2017 04:40:56 GMT

Hi all,

sounds like stupid question but i just can't get the text colour or background colour to work in this instance...

I have been able to in other instances but here it's not working for me...

I have qlikview pivot chart, in which I have a dimension (ISHCQTYAvailable) which has been pre-calculated in the load script, this gives the quantity available for a particular product.

I want the text to be red if it's in the negative, and green if it's in the positive and black, if it's just 0.

So in "Text Colour" under that dimension I have the following:

=IF(ISHCQTYAvailable > 0, Green(),

IF(ISHCQTYAvailable < 0, Red(), Black()))

why isn't this working for me - any ideas?

Thanks in advance everybody!!

Fab

Re: Text Colour and Background colour in a Pivot Chart

Anil_Babu_Samineni — Thu, 14 Sep 2017 04:43:05 GMT

Can you provide work file to test

Re: Text Colour and Background colour in a Pivot Chart

vvira1316 — Thu, 14 Sep 2017 04:47:09 GMT

You are trying to do Dimension background color or the expression background color?

Re: Text Colour and Background colour in a Pivot Chart

Anonymous — Thu, 14 Sep 2017 04:47:31 GMT

I would love to Anil,

But unfortunately this is part of a pretty large qlikview report, which is connected to our in house DB via ODBC...

I was hoping someone would be able to comment on my code...

thanks for your interest though...

Fab

Re: Text Colour and Background colour in a Pivot Chart

prma7799 — Thu, 14 Sep 2017 04:49:44 GMT

Try like this or Please share some sample app

Go to expression >>Text Color >>

if( ISHCQTYAvailable >=0 ,Green(),

if( ISHCQTYAvailable < 0 ,red(),

Black() ) )

Re: Text Colour and Background colour in a Pivot Chart

Anonymous — Thu, 14 Sep 2017 04:53:21 GMT

Hi Vijay,

My field is a dimension, not an expression...

It's been pre-calculated in the load script...

Thanks

Re: Text Colour and Background colour in a Pivot Chart

prma7799 — Thu, 14 Sep 2017 04:56:24 GMT

Please share some sample app

Re: Text Colour and Background colour in a Pivot Chart

Anonymous — Thu, 14 Sep 2017 05:02:40 GMT

Hi all,

thanks for your input...

I've just converted by pivot table into a straight table and the colours work no problems

Does anyone know how I can make text and background colours work (in dimensions) within a pivot table?

I don't understand why a feature like this would work in a straight chart but not a pivot chart???

Re: Text Colour and Background colour in a Pivot Chart

prma7799 — Thu, 14 Sep 2017 05:09:35 GMT

You can use it in dimension

Go to dimension >>Background Color >> ( Put those column no. which you want to apply on that basis)

e.g.

if( Column(2)>=0 ,Green(),

if( Column(2)< 0 ,red(),

Black() ) )

Re: Text Colour and Background colour in a Pivot Chart

prma7799 — Thu, 14 Sep 2017 05:15:01 GMT

Re: Text Colour and Background colour in a Pivot Chart

mostwanted123 — Thu, 14 Sep 2017 05:22:31 GMT

Hi Fabrizio,

Try like this,

Go to expression -->Text Color -->

if( ISHCQTYAvailable >=0 ,rgb(0,128,0),

if( ISHCQTYAvailable < 0 ,rgb(255,0,0),

rgb(0,0,0) ) )

Regards,

Pratik

Re: Text Colour and Background colour in a Pivot Chart

Anonymous — Thu, 14 Sep 2017 05:29:00 GMT

Hi PM,

Thanks for your post and instructions...

That's exactly what I did and it works in a straight table but not a pivot table..

I have no Null values in thus dimension (there was a bug that was mentioned elsewhere about NULLs and colour)

Does your colour work if your chart is a pivot Table?

Re: Text Colour and Background colour in a Pivot Chart

Anonymous — Thu, 14 Sep 2017 05:31:37 GMT

hi Pratik,

same thing unfortunately - works in straight table but not in a pivot table...

got me scratching my head... i need this in pivot table format, and i don't want to make this an expression... I don't understand why this won't work in a pivot table....

anyone come across this?

Re: Text Colour and Background colour in a Pivot Chart

prma7799 — Thu, 14 Sep 2017 05:39:58 GMT

Yes Its works...

Please try and let me know.

Re: Text Colour and Background colour in a Pivot Chart

mostwanted123 — Thu, 14 Sep 2017 05:49:40 GMT

Hi Fabrizio,

Can you share your qvw file ?

Re: Text Colour and Background colour in a Pivot Chart

Anonymous — Thu, 14 Sep 2017 05:50:47 GMT

Hi PM

I appreciate your feedback...

Can you please explain what <Column (2)> represents in your picture?

If my dimension is <QTYAvailable> isn't that what I should be referencing in my colour expression?

if ou could let me know that would be great...

thanks

Fab

Re: Text Colour and Background colour in a Pivot Chart

afsarshaikh — Thu, 14 Sep 2017 05:55:03 GMT

Try,

if( len((ISHCQTYAvailable) > 0, Green(),

if( len((ISHCQTYAvailable) < 0, Red(), Black()

))

Re: Text Colour and Background colour in a Pivot Chart

Anonymous — Thu, 14 Sep 2017 05:56:46 GMT

I can't Pratik unfortunately,

it is way too large and it connects to our in house ODBC, plus it's confidential information...

I understand this makes it hard though and appreciate any help...

Re: Text Colour and Background colour in a Pivot Chart

prma7799 — Thu, 14 Sep 2017 06:01:39 GMT

Column (2) is my measurable value.

You have to take reference for your column on which criteria you want to color your dimension above screen shot showing sales % wise therapy with background color

Re: Text Colour and Background colour in a Pivot Chart

Neymar_Jr — Thu, 14 Sep 2017 06:07:43 GMT

May be this

IF(ISHCQTYAvailable > 0, 'Green()',

IF(ISHCQTYAvailable < 0, 'Red()', 'Black()'))