topic Re: data types issues in Qlik SaaS cloud in Move to Qlik Cloud Analytics

data types issues in Qlik SaaS cloud

Raju_6952 — Tue, 27 Jan 2026 10:45:26 GMT

Hi there,

we have recently noticed that if any filed that has both num and text values are being considered as text only instead of text and num. we have observed this for handful of fields is there a way to address it in the load script or by using any predefined variables.

Thanks in Adavance!

Regards,

Raju

Re: data types issues in Qlik SaaS cloud

Daniel_Pilla — Fri, 03 Jan 2025 14:05:30 GMT

The Dual() function allows for a field value to have both a text and numeric representation.

Re: data types issues in Qlik SaaS cloud

Raju_6952 — Fri, 03 Jan 2025 14:10:18 GMT

Hi @Daniel_Pilla ,

thanks for the update!

but we have lot of fields like this in one single app and we are suspecting that it would also the case with some other apps as well.

Do you mean like we have to address this issue manullay for each field?

Regards,

Raju

Re: data types issues in Qlik SaaS cloud

Daniel_Pilla — Fri, 03 Jan 2025 14:49:32 GMT

Certain fields are automatically Dual()'d such as when Qlik recognizes that a field is a date field. You will need to wrap any field that you want to have a custom Dual() representation manually, yes.

Re: data types issues in Qlik SaaS cloud

Raju_6952 — Mon, 06 Jan 2025 05:43:53 GMT

Hi @Daniel_Pilla ,

Many thanks for the clarification.

Regards,

Raju

Re: data types issues in Qlik SaaS cloud

Raju_6952 — Wed, 22 Jan 2025 06:53:09 GMT

Hi @Daniel_Pilla ,

We observed this issue while fecthing data into SaaS thorugh data gateway service from HANA but on enterprise edition it works fine.

do you think its a bug in saas or its working as designed?

Regards,

Raju