Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

tsoley9262
New Contributor III

If Else statement in a expression

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!!

2 Replies
wandererroch
New Contributor III

Re: If Else statement in a expression

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
)
tsoley9262
New Contributor III

Re: If Else statement in a expression

Thanks that worked great!!