Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Read excel cell colour & column name into Qlik Sense

I've recently been given a problem to try and solve using Qlik Sense and I'm struggling to get the "meta" data I need from excel.

The excel sheet is auto generated so I don't have the ability to change it but one of the columns is basically just for colours so if the colour is green its true and false if red.

In the excel sheet its just a colour but when reading the sheet into qlik I'd like to be able to say something like

If (cellColour = Green)

     return true

Or something similar to that. So in qlik I will see true and false instead of just blank cells.

Also there are multiple columns in this sheet that have the same typed header first row but the column names in excel are different. Is there anyway to get a hold of these column names? These aren't the first row they are actually a name assigned to the column in excel.

I appreciate any help with this.


0 Replies