Vern
Vern

Reputation: 3

Qlik Sense Load Editor. All the sudden field not found when using IF statement

The script runs okay when just the field name is specified.

But when using IF statement, it gives error that if field not found.

What is the issue and how to fix it?

"IF(ISNULL(mcdRegion),'',(mcdRegion)) as [Region]"

Upvotes: 0

Views: 551

Answers (1)

Chris Grossman
Chris Grossman

Reputation: 11

I think for the field name in your 'other' condition you swap out the () for [] or leave open since the field doesn't have spaces. So it would be:

IF(ISNULL(mcdRegion),'',[mcdRegion]) as [Region]

or

IF(ISNULL(mcdRegion),'',mcdRegion) as [Region]

Upvotes: 1

Related Questions