Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formula not working

Hi,

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

Capture.PNG

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

Capture.PNG

1 Solution

Accepted Solutions
sunny_talwar

What if you try this:

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

HTH

Best,

Sunny

View solution in original post

3 Replies
Clever_Anjos
Employee
Employee

maybe there are some spaces or mistypes, please check

sunny_talwar

What if you try this:

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

HTH

Best,

Sunny

fred_s
Partner - Creator III
Partner - Creator III

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