Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Re: Text Colour and Background colour in a Pivot Chart

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

Highlighted
Creator
Creator

Re: Text Colour and Background colour in a Pivot Chart

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?

Highlighted
Creator
Creator

Re: Text Colour and Background colour in a Pivot Chart

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?

Highlighted
Master III
Master III

Re: Text Colour and Background colour in a Pivot Chart

Yes Its works...

Please try and let me know.

Highlighted
Creator
Creator

Re: Text Colour and Background colour in a Pivot Chart

Hi Fabrizio,

Can you share your qvw file ?

Highlighted
Creator
Creator

Re: Text Colour and Background colour in a Pivot Chart

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

Highlighted
Creator
Creator

Re: Text Colour and Background colour in a Pivot Chart

Try,

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

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

))

Regards,
Afsar Shaikh
Project Manager- QlikView Dev. & Support
Afsar Shaikh
Email- afsar.shaikh@live.com
Highlighted
Creator
Creator

Re: Text Colour and Background colour in a Pivot Chart

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...

Highlighted
Master III
Master III

Re: Text Colour and Background colour in a Pivot Chart

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  

Highlighted
Creator II
Creator II

Re: Text Colour and Background colour in a Pivot Chart

May be this

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

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