Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have to create a simply function.
IF (Sosta='Y', count(MancatoCarico),44000)
The result is always 44000. What's wrong?
Maybe Sosta is never 'Y' ...
Qlik is case sensitive, maybe is 'y' or maybe you have Y is in fact ' Y'
try
IF (lower(trim(Sosta))='y', count(MancatoCarico),44000)
hth
Sasi