Here, the main problem is even excel also. If your condition is not running the correct syntax it won't work. For your case, If(1> ??, 0,1) -- I am not sure whether the condition on any other tool like QV. Qlikview don't have capable to understand what does the value after > they need to sort. Atleast '' should be there then qlik and other software has that power.
Life is so rich, and we need to respect to the life !!!