Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
triekong
Creator
Creator

Chart: Bars in different colors

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!

1 Reply
triekong
Creator
Creator
Author

i found my error. thanks!