Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get diiferent color on a column depending on the current month of the year??
I want to get the column with diiferent color , showing the data of current month of the year ??
Go in expression, click on
and set in the background property your condition
(i.e. if(month='january', rgb(255,0,0), rgb(0,0,255))
Chart Properties > Visual cues --fix colour for column level
Sorry, I should mention that , Month is a dimension.
And I only have to color the current month column.
Sorry, I should mention that , Month is a dimension.
And I only have to color the current month column.
It works even if month is a dimension,
you may have problems if the density is not 100% (not all values are coloured). in this case try something like this
if(Odd(min(TOTAL <month> month)), color1, color2)
But in my qlikview model :
Month is not there in Expression tab.
So, I am unable to set the expression:
if(month='january', rgb(255,0,0), rgb(0,0,255)
Plz tell me step by step,
I am new to qlikview.
You told that month is a dimension, so go in all the expression where you need to change colour (the expression isn't about month) and click on
go in the background and write the expression I sent to you ...
Hope it helps