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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

How to get diiferent color on a column??

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 ??

7 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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))

Not applicable

Chart Properties > Visual cues --fix colour for column level

suvechha_b
Creator III
Creator III
Author

Sorry, I should mention that , Month is a dimension.

And I only have to color the current month column.

suvechha_b
Creator III
Creator III
Author

Sorry, I should mention that , Month is a dimension.

And I only have to color the current month column.

alexandros17
Partner - Champion III
Partner - Champion III

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)

suvechha_b
Creator III
Creator III
Author

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.

alexandros17
Partner - Champion III
Partner - Champion III

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