Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

correcting typos in script

We have a situation where spelling mistakes and capitals are causing repeat site names when I link QV to one of my databases.

Unfortuately the field in the db is free text and not a drop down. Can I fix this in the QV script so there is only one occurrence?

e.g uses are entering SITE A, Site A, site a and ste A (these are all the same sites)

Thanks

1 Reply
rajni_batra
Valued Contributor

Re: correcting typos in script

you can use capitalise(Field name) it will give Site A for all but unfortunately not for ste A

Community Browser