topic Using '-' (dash) in If Statement in QlikView

Using '-' (dash) in If Statement

gozdamar — Mon, 26 Jan 2026 16:26:21 GMT

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!

Re: Using '-' (dash) in If Statement

stevejoyce — Thu, 16 Sep 2021 11:28:17 GMT

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.