This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I want to colour background EXPR1 and wrote this in BACKGROUND COLOR:
if (Sum([EXPR1]) <= NUM, $(vColorBlack), $(vColorGreen))
The colors don't appear.
What should I write? I use varaibles because the colors can be changed very fastly.
Message was edited by: cristina lovati
Sunny and Gysbert...u guy's having eagle eyes
View solution in original post
Is EXPR1 a field or is this expression label here? Also try the variables without the dollar sign expansion:
If(Sum([EXPR1]) <= NUM, vColorBlack, vColorGreen)
Have you put this expression as suggested in the following post?
Using RGB() and ARGB() to define colors
If not, try it. If yes, how and where did you wrote yiur variables?
Hope this helps,
The syntax of the expression you posted looks correct. Can you post a small qlikview document that demonstrates the problem?
if (Sum([EXPR1]) <=10, NUM, $(vColorBlack), $(vColorGreen))
if its not working check the file
Sorry forgot to mention : U also need to use condition:
It should work without dollar signif (Sum([EXPR1]) <= NUM, vColorBlack, vColorGreen)
Just attached. The wish is in the background of the only expression (in comment). Thanks
Seems to be working for me
The only issue was the one of the variables were using ARGC instead of ARGB