Discussion board where members can get started with Qlik Sense.
I have a big issue in my Bar chart. It's setted as grouped and vertical.
As Dimention I have the months of the year, and as measures I have the total value of three years of sales (2013, 2014, 2015).
I'm trying to change the color of the year's columns on the chart.
I'm trying to set:
-2013's columns, intto grey.
-2014's columns into blue.
-2015 columns into yellow.
I tried this formula, but I changes all the cloumns of the chart to blue.
IF( Sum(), yellow(), if( Sum(), blue(), rgb(199, 199, 199)))
I would like to know what's wrong in my formula and if there is a better way to do it.
I attached a screenshot of the original chart( without the formula) and a screenshot with the formula to facilitate.
Thanks a lot in advance.
Go to Solution.
you can colour a bar chart/ Stacked bar chart the way you like to.
This possible by adding 2 dimensions and 1 Measure. Check the QVF attached for more details.
If you are facing any issues achieving this, please attach a sample QVF and I will help you achieve it.
Thanks and Regards,
your example helped me a lot and now my charts are colorful with the colours I needed.
Thank you very much.