Discussion Board for collaboration related to QlikView App Development.
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.
Go to Solution.
Exactlly, you are using ARGB with alpha value. Excel cannot understand it. Change colour values to RGB function.
View solution in original post
Are you using Alpha values?
Excel cannot undestand Alpha values, use RGB function or colour function without Alpha value.
sorry, here is the app joigned in the first post.
I thnik that you are right, I have to use RGB instead of ARG ...