Hi I am having trouble creating and if function to change the background colour of cost >= 5000 within this table could anyone please help me correct my formula.
hi, I was also wondering if it possible to create an if-function which generates a yes or no response based on whether a particular staff approved quantities greater than 3000 for the following table.
Thanks in advance.
Seems, You are working with Qliksense. There you need to write from Colors tab by using Measure. Then only it will give some output. Any how, Your expression seems okay. Would you tell us where do you copy and paste this expression.
PS: Still, you are not figure it out then please share QVF file with us
Hi Shamila, in expression editor you can't use measures by name, you have to use the fields loaded in the app, I think the easiest way is to copy the content of the measure, like:
I'm not fully understanding your second question. Maybe?:
If(sum(quantity)>3000, 'yes', 'no')