Non export of conditionnal color in Excel

[#1]

Hello,

I am developping an app where I try to do conditionnal color like this:

     If(test=OK, color1, color2)

Which give this result in the Qlikview app (the result is OK):

When I put directly the RGB code like (RGB(255,0,0) in the code, export is OK. I have 2 different colors in the Excel file (see the first column).

BUT when colors are parameters or come from the script, I have only one color... (columns 2 and 3) in the Excel:

How can I do to have my conditionnal colors in the Excel export ?

I want to use my load inline table, because as you see I have 2 * 25 colors to declare.

Thank you,

Willy

[Anonymous]

Hi Willy,

Are you using Alpha values?

Excel cannot undestand Alpha values, use RGB function or colour function without Alpha value.

Regards!

[#3]

Hi Manuel,

sorry, here is the app joigned in the first post.

Willy

[#4]

I thnik that you are right, I have to use RGB instead of ARG ...

[Anonymous · Accepted solution]

Exactlly, you are using ARGB with alpha value. Excel cannot understand it. Change colour values to RGB function.

Regards!

[#6]

Thank you

[Anonymous]

You're wellcome