topic Formula not working in QlikView

Formula not working

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

Can anyone help me to figure this out. I am loading the file, and changing one of the fields in the script

However, created field 'Repeat' only shows '0', even if the was 'No' in the original file.

Clever_Anjos — Thu, 26 Mar 2015 19:01:13 GMT

maybe there are some spaces or mistypes, please check

sunny_talwar — Thu, 26 Mar 2015 19:03:59 GMT

What if you try this:

If(Capitalize(Trim(yourField)) = 'Yes', 1, 0) as Repeat

HTH

Best,

Sunny

fred_s — Thu, 26 Mar 2015 19:20:04 GMT

Hi Nina,

Don't use as "Repeat" but as Repeat.

And in addition to Clever, besides checking the fieldname, check Yes/No for the exact same use of capitals.

Grtz Fred