topic Re: String Conversion in Qlik Sense in QlikView

String Conversion in Qlik Sense

JayDashtii-911 — Thu, 15 Dec 2022 05:46:52 GMT

Hey there,

I'm using the below function in SQL

UTL_I18N.ROW_TO_CHAR(FIELD_NAME, 'AL16UTF16')

Is there a built-in function to do the same on QVD instead of SQL?

settu_periasamy — Thu, 15 Dec 2022 08:22:04 GMT

what is the expected result ?

JayDashtii-911 — Thu, 15 Dec 2022 08:32:23 GMT

There is a field in our database which is encoded by IT DEPARTMENT, and I have to use this function to display the string in qlik sense.

I’m running the SQL query and store it into a QVD, is there a way to do the same on QVD fields instead of SQL?

settu_periasamy — Thu, 15 Dec 2022 09:12:34 GMT

can you give any example, how the values are encoded and stored into QVD while running the SQL Query ?

Bill_Britt — Thu, 15 Dec 2022 11:46:38 GMT

You need to the conversion before you store it in a QVD. It slows down the read speed if you are doing conversion when you are loading data from the QVD.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/QVD_files.htm

If you are worried about security you can always setup QVD encryption.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Server/Content/QV_Server/QlikView-Server/QVSRM_EncryptionCertificates.htm