Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Is it possible to load Colored cells of an excel sheet.?

Input- An excel file with status field  shown in color codes and not figures.(Ex- >80%-Green color cell,<80% -red color cell).

Question- how to load  this color coded value of cells in qlik view scripting ??

2 Replies
MVP & Luminary
MVP & Luminary

Re: Is it possible to load Colored cells of an excel sheet.?

That's not possible. The formatting of an excel cell is not imported, only the value. You'll have to recreate the color calculation in Qlikview. You could for example add a field in the script in the load statement:

LOAD

     Value,

     If(Value < 0.8, rgb(255,0,0), rgb(0,255,0)) as Color

FROM

     ...MyExcelFile...;

You can use the Color field in an expression for the Background Color option of a chart expression. Click on the + in front of the expression on the Expressions tab of the charts properties window. Select the Background Color option and add as color expression =only(Color)


talk is cheap, supply exceeds demand
Partner
Partner

Re: Is it possible to load Colored cells of an excel sheet.?

Thanks for the reply.

In the excel file only informatory field is shown in colors.

Hence,we cannot use iif value <x ,red or green.

My aim is ti find a mapping for all colors at qlikview level..but how to load those colors to qv is npt possible as per you.