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)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
If I have a measure as a master item called (Country missing) and I have used this as a measure in my pivot table, how do I ensure that the if this measure is greater than 0 the text in the pivot table is red and green if not ?
Go to your measure in the pivot table options, and edit the text color expression to something like
If([Measure] > 0, red(), green())
View solution in original post
Click the plus by the dimension or expression (depending on what you want to be green). Then double click on the "Text color" and type this:
if(Measure > 0,RGB(0,128,0),