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
Hmm....So there is no way to get the colours...????
No thats not possible .. as far as i know
Regards,
anant
Dammm .....
So is there any other way by which I can achieve my requirements..??
Hi,
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.
Best Regards
Peyman
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()
Regards,
anant
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.
i will make a sample excel file and attach in next response asap
Regards
Peyman
Thanx Alot..