Discussion board where members can get started with Qlik Sense.
I am trying to use an if statement, but i get an error when i type it.this is the formula: If(Avg((If([Daily Change %]>0,1,0)))>0.8,"Invest","Dont Invest")
this statement does work and it gives a value between 0-1:Avg((If([Daily Change %]>0,1,0)))
Go to Solution.
Replace your double quotes with single quotes and try like:
If(Avg((If([Daily Change %]>0,1,0)))>0.8, 'Invest', 'Dont Invest')
Note: With double quotes, qlik looks for a field rather than treating it as a string.
Do you want to use this in a table or KPI object?