Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
)

View solution in original post

tsoley9262
Contributor III
Contributor III
Author

Thanks that worked great!!