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 ).
So is there any other way by which I can achieve my requirements..??
if the data structure in excel is not complicated and you can do a pre proccess on excel file before loading in QV, you can add some columns to Excel file and use excel functions such as ColorIndex(A3) to get the colors of cells in two new columns. then you can read it and process the color info in your QV app.
you can iport put your excel data into qlikview once loaded put in pivot/staright table
then you can expand your dimension or expression and put color function red() or green()
Can you please explain a little more..?? Colorindex() function is giving an Error msg.
No, This is not gonna work. I have a huge amount of data which is categorized on color basis, cant do on a pivot table.