Discussion Board for collaboration related to QlikView App Development.
Just a simple question. I am trying to set the text color expression in a pivot table by doing:
However, it does not work. The negative number are still in green.
try with aggregation, if(sum(NPM_TOTAL_SALES)<= 0,'red','green')
View solution in original post
Use it like : IF(NPM_TOTAL_SALES<= 0,red(),green()) or IF(NPM_TOTAL_SALES<= 0,rgb(255,0,0),rgb(0,255,0))
Use the above.
Besides why not trying.
Keep in mind the below option works only with expressions:
Thanks. However it does not work.
can you send us screenshot of your graphice and expression please?
try to add expression with if(NPM_TOTAL_SALES<= 0,'KO','OK') in the graphic and look if it works fine.
Now it works 🙂