topic QlikView Type Conversion Issues in QlikView https://community.qlik.com/t5/QlikView/QlikView-Type-Conversion-Issues/m-p/626320#M230288 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>We currently have several QV dashboards which consist of 3 Tier architecture. Tier 1 loads raw data, Tier 2 Manipulates the data, and Tier 3 is simply a way to view the data. We are experiencing an issue, following a load from Tier 1 where we set the type of a field to be text using the Text(Field) function and then store it into the QVD, when Tier 2 loads that data it seems to lose that conversion. Our data is semi-alpha-numeric meaning that some of it contains letters and numbers and some of it is purely numbers. All of our data needs to be viewed as strings.</P><P></P><P>Generally speaking we would be fine forcing that conversion at all tiers but we lose the optimized load when we do that. Has anyone had any similar experiences?</P><P></P><P>Thank you,</P><P>Clayton</P></BODY></HTML> Thu, 08 May 2014 12:10:46 GMT 2014-05-08T12:10:46Z QlikView Type Conversion Issues https://community.qlik.com/t5/QlikView/QlikView-Type-Conversion-Issues/m-p/626320#M230288 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>We currently have several QV dashboards which consist of 3 Tier architecture. Tier 1 loads raw data, Tier 2 Manipulates the data, and Tier 3 is simply a way to view the data. We are experiencing an issue, following a load from Tier 1 where we set the type of a field to be text using the Text(Field) function and then store it into the QVD, when Tier 2 loads that data it seems to lose that conversion. Our data is semi-alpha-numeric meaning that some of it contains letters and numbers and some of it is purely numbers. All of our data needs to be viewed as strings.</P><P></P><P>Generally speaking we would be fine forcing that conversion at all tiers but we lose the optimized load when we do that. Has anyone had any similar experiences?</P><P></P><P>Thank you,</P><P>Clayton</P></BODY></HTML> Thu, 08 May 2014 12:10:46 GMT https://community.qlik.com/t5/QlikView/QlikView-Type-Conversion-Issues/m-p/626320#M230288 2014-05-08T12:10:46Z