Using '-' (dash) in If Statement

[gozdamar]

Hello all,

I am trying to write very easy if statement in table expressions. If the cell is '-', I want to see 'x':

if (Column1 = '-', 'x', 'y')

Somehow, Qlikview cannot recognize dash ('-'). Is this a kind if bug, or am I missing something?

Thanks a lot!

[stevejoyce · Accepted solution]

Nulls display as - by default, so are you sure this isn't actually null?  If so, there are a few functions in the load script that can handle (coalesce, alt for numeric values, if-statement). 

if it's front-end you can do: if (isnull(Column1) = '-', 'x', 'y').  alt would work also but again for numeric values.