Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT 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 - Specialist
Partner - Specialist

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