Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Raju_6952
Creator III
Creator III

data types issues in Qlik SaaS cloud

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

Labels (3)
5 Replies
Daniel_Pilla
Employee
Employee

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

Raju_6952
Creator III
Creator III
Author

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

Daniel_Pilla
Employee
Employee

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.

Raju_6952
Creator III
Creator III
Author

Hi @Daniel_Pilla ,

Many thanks for the clarification.

Regards,

Raju

Raju_6952
Creator III
Creator III
Author

 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