Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

What does applycodepage() do?

I have seen applycodepage() in Qlikview reference manual and have done some google on it to see. From what I've understood it is to change code standard from standard to another. But, its still gibberish to me. Can someone tell me in layman words, what exactly it does?

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: What does applycodepage() do?

Let's say that your Qview Application contains data sales from Asia, America en Europe. So product description would have different ways to visualize on the screen. Based on the user being analyzing the document you can apply the codepage on that product decription at run time in an expression.

Ie:

Add a Calculated Dimension based on [PRODUCT DESCRIPTION] and in the Definition.

applycodepage(1201,[PRODUCT DESCRIPTION])   for users from Asia

or

applycodepage(65001,[PRODUCT DESCRIPTION]) for the rest of users

where 65001 is UTF-8 and 1201 UTF-16BE

note that the above are just examples , you can even have the codepage in a variable

applycodeepage($(myLocationCodePage),[PRODUCT DESCRIPTION])

or

applycodepage([MY FIELD CONTAINING CODEPAGE SELECTED AUTOMATICALLY], [PRODUCT DESCRIPTION])

hope this helps,

2 Replies
Not applicable

Re: What does applycodepage() do?

Let's say that your Qview Application contains data sales from Asia, America en Europe. So product description would have different ways to visualize on the screen. Based on the user being analyzing the document you can apply the codepage on that product decription at run time in an expression.

Ie:

Add a Calculated Dimension based on [PRODUCT DESCRIPTION] and in the Definition.

applycodepage(1201,[PRODUCT DESCRIPTION])   for users from Asia

or

applycodepage(65001,[PRODUCT DESCRIPTION]) for the rest of users

where 65001 is UTF-8 and 1201 UTF-16BE

note that the above are just examples , you can even have the codepage in a variable

applycodeepage($(myLocationCodePage),[PRODUCT DESCRIPTION])

or

applycodepage([MY FIELD CONTAINING CODEPAGE SELECTED AUTOMATICALLY], [PRODUCT DESCRIPTION])

hope this helps,

Not applicable

Re: What does applycodepage() do?

Thanks for explaining in detail

Community Browser