topic Re: color graph in QlikView

color graph

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

i have a dimension calculated in this way:

=if(isnull(Invoice_DocNumber),'Not Invoiced',

round((MonthEnd(Invoice_Date_Num)-MonthEnd(SurgeryDate))/30)
)

this is used in a bar graph.

How i can change the bar color when the value is "Not Invoiced" ?

i tried If(isnull(Invoice_DocNumber),rgb(255,255,255),rgb(30,60,32)) but is not working

any idea ?
Thank you!

Re: color graph

Frank_Hartmann — Fri, 27 Sep 2019 17:53:36 GMT

Maybe like this:

=if(if(isnull(Invoice_DocNumber),'Not Invoiced',round((MonthEnd(Invoice_Date_Num)-MonthEnd(SurgeryDate))/30))='Not Invoiced',rgb(255,255,255),rgb(30,60,32))

Re: color graph

Brett_Bleess — Tue, 08 Oct 2019 15:02:55 GMT

If Frank's post did not do the trick, have a look at the following Design Blog post, might help:

https://community.qlik.com/t5/Qlik-Design-Blog/How-to-custom-color-a-stacked-bar-chart/ba-p/1465653

Here is the base link to the Design Blog area in case you want to further search on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett