topic Re: If Else statement in a expression in QlikView

If Else statement in a expression

tsoley9262 — Mon, 26 Jan 2026 18:19:17 GMT

I currently have a statement that works

([Completed Count]+[Management Host]) / ([Grand Total])

I am trying to add

If([Completed_Date]> ' ' ,([Completed Count]+[Management Host]+ {Roadblock_Count) / ([Grand Total]) elseif ([Completed Count]+[Management Host]) / ([Grand Total])

Thanks for your help!!

Re: If Else statement in a expression

wandererroch — Tue, 12 Feb 2019 18:47:01 GMT

The syntax is if(Expression, True expression, false expression)
so yours would be something like
If([Completed_Date] = ' ' ,
([Completed Count]+[Management Host]+ {Roadblock_Count) / ([Grand Total]) , //True
([Completed Count]+[Management Host]) / ([Grand Total]) //False
)

Re: If Else statement in a expression

tsoley9262 — Tue, 12 Feb 2019 18:57:58 GMT

Thanks that worked great!!