Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Condition on dimension n barchart-ASAP

Hi

i have month as dimension in bar chart.

i want to use multiple condtions in that field like if jan is red feb is bluue and june the green like more than three conditions bar s color should be changed

1 Reply
Gysbert_Wassenaar

You can enable the option Multicolored on the Colors tab of the properties window. Each month will get its own color. Or you can click on the + in front of the expression on the Expressions tab, select Background Color and enter an expression that picks a color for each month. For example =pick(match(Month,'Jan','Feb','Jun'),red(),blue(),green()). Jan, Feb and Jun will be red, blue and green respectively. The other months will get the color that's set as the first color on the Colors tab. You can add the other months to the expression in the match function and their colors in the pick function. Make sure you use the exact values of your Month dimension in the match function. QV is case sensitive so Jan is not the same as jan.


talk is cheap, supply exceeds demand