statement if

[fmazzarelli]

Hi Community,

I have to create a simply function.

IF (Sosta='Y', count(MancatoCarico),44000)

The result is always 44000. What's wrong?

[alexandros17]

Maybe Sosta is never 'Y' ...

[robert_mika]

Qlik is case sensitive, maybe is 'y' or maybe you have Y is in fact ' Y'

[sasiparupudi1]

try

IF (lower(trim(Sosta))='y', count(MancatoCarico),44000)

hth

Sasi