Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Can you perform a function similar to "=proper(text)" for a field of data in QlikView script?

I am looking to clear up 'Insured party' by using proper text format like in Excel.

I have over 100,000,000 lines of data and therefore cannot use the 'from' to 'to' function from an Excel spreasheet (as too many rows!) to clear this up and mapp it in the script. I have also used a .csv format and a .txt format with the 'from' to 'to' function and it still doesn't change the cases of the text for insured party in the dashboard.

Does any one know any other ways of doing it?

Many thanks.

John

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Can you perform a function similar to "=proper(text)" for a field of data in QlikView script?

 

Capitalize ([Insured Party]) as [Insured Party]

3 Replies
mayilvahanan
Not applicable

Re: Can you perform a function similar to "=proper(text)" for a field of data in QlikView script?

HI

Try Capitalize() function

Hope it helps

Not applicable

Re: Can you perform a function similar to "=proper(text)" for a field of data in QlikView script?

Thanks, how do I use this function on a column from external data (Excel spreadsheet) ?

I have tried Capitalize([Insured Party]) & Capitalize('[Insured Party]') with no success.

Many thanks.

John

Not applicable

Re: Can you perform a function similar to "=proper(text)" for a field of data in QlikView script?

 

Capitalize ([Insured Party]) as [Insured Party]