Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
PeBo
Contributor
Contributor

how to color total value in stacked bar chart using custom text color

Hi,

I have a stacked bar chart and I'm using custom values for the coloring of the background and text. It's working fine, only the TOTAL value cannot be colored correctly:

PeBo_0-1601286282697.png

As text color formula for a table diagram I used this one, which is working perfectly for the total values, where rowno() is NULL:

if( isnull(rowno())
,
rgb(0,0,0)
,
rgb(ColorCodeTextR,ColorCodeTextG,ColorCodeTextB)
)

 

But it seems for a bar chart the total value has not NULL as rowno(). It always uses the text color of the upper value, so sometimes it's white and sometimes it's black. I need it always in black.

Thanks for your suggestions! 

Labels (5)
1 Reply
Brett_Bleess
Employee
Employee

The only thing I have is the following Design Blog post, read through some of the initial comments, did not see anything directly related to your post, but you may be able to post there and get Henric to respond back to things there.  The only thing I can figure in this case is there is some sort of timing issue here related to when something gets populated in the backend that is likely impacting things and not working as you want, but I have no idea if this would be a defect or not.  If you are using a current version of the product and have an app that can replicate things, it may be best to just submit this as a support case with the app attached and instructions on replication such that it can be sent over to the engineers to determine if there is a possible defect or not.  Generally they will explain why it is or is not once they look into things.  

That all being said, the one thing I did notice is the black bar at the top on the right side that has no number but that is missing on the bar on the left, so it may have something to do with that too.  Sorry I do not have anything better.

https://community.qlik.com/t5/Qlik-Design-Blog/Colors-in-charts/ba-p/1475280

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.