Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I are working on an assignment in which i collect data on an excel sheet and categories them on the basis of particular color.
Now I want to consolidate all workbooks along with the color given in excel sheet.
So please let me know is it possible to get data from excel sheet in to Qlikview along with the color given to it in Excel Sheet. ( Both Font color & Background Color ).
Regards
Jyothish KC
Ok,
please notice that i have two Functions in my Excel File defined:
Function CellBGColor(Optional myCell As Range)
CellBGColor = myCell.Interior.ColorIndex
End FunctionFunction CellFontColor(Optional myCell As Range)
CellFontColor = myCell.Font.ColorIndex
End Function
Regards
Peyman
Thanx for the reply, but this not going to help me... , I want data along with the color in QV.
first you need to read color information from excel. as mentioned you cen produce color info with two functions in excel.
then you need to read this color data alonwith your main data.
in QlikView you need to map the color data from excel to QV colors and atlast you usr this translated color info in background expression or everywhere you need it.
Regards
Peyman