Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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!