color graph

[qlikviewaf]

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!

[Frank_Hartmann]

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

[Brett_Bleess]

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