Chart: Bars in different colors

triekong — Wed, 11 Apr 2018 22:53:43 GMT

Hi guys,

I have created a bar chart, has multiple values. all i want is have another color for the values less than 5000, by individual categories.

PROBLEM: I know changing the 'background color' in the expression will change the color of the bars, but my expression is a variable, and when I put in the variable, it is not working.

i want the bars to differ in color by their values and category.

My variable comes from the "Actual" button selection. the formula being passed is:

=(sum(

(if(Period='MTD' and v_CurrencyButton=0,[MTD Actuals Global Currency],

if(Period='MTD' and v_CurrencyButton=1,[MTD Actuals Constant Currency],

if(Period='QTD' and v_CurrencyButton=0, [QTD Actuals Global Currency],

if(Period='QTD' and v_CurrencyButton=1,[QTD Actuals Constant Currency],

if(Period='YTD' and v_CurrencyButton=0,[YTD Actuals Global Currency],

[YTD Actuals Constant Currency]))))))))

what am i doing wrong?

thanks!

Re: Chart: Bars in different colors

triekong — Thu, 12 Apr 2018 15:56:34 GMT

i found my error. thanks!

topic Chart: Bars in different colors in QlikView

Chart: Bars in different colors

Re: Chart: Bars in different colors