Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.