Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tsoley9262
Contributor III
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!!

1 Solution

Accepted Solutions
wandererroch
Contributor III
Contributor III

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
)

View solution in original post

2 Replies
wandererroch
Contributor III
Contributor III

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
Contributor III
Contributor III
Author

Thanks that worked great!!