Load Color Data from Excel into QlikSense Desktop

[asifshah]

Hi everyone, this is my first post on this community so please forgive me if I make any mistakes in this post.

I have an Excel sheet containing attendance data for employees. The attendance marking for each employee is denoted by a color (e.g. Orange = Present, Blue = On Leave, etc). 

Is there any way I can load this data into QlikSense application?

Example

[lironbaram · Accepted solution]

hi 

i don't think you can load the cells color as far a Qlik we only load the values in the cell 

[Ivan_Bozov]

Hi! You cannot load the color. What you need is an additional column in your data, e.g. called 'Status' with field values 'present', 'on leave', etc.

Then in the front end you can use color by expression, e.g.

IF(Status='present', RGB(255,128,0),
IF(Status='on leave', ...

Another option is to create a master dimension and assign colors to the different values there.

Also keep in mind that your current data in not in a good shape to be loaded directly and would need some transformation. Check this help page: https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...