2 Replies Latest reply: Dec 29, 2014 1:42 AM by Eddie Morah RSS

    What does applycodepage() do?

    Eddie Morah

      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?

        • Re: What does applycodepage() do?
          Mario Estrada

          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,