https://community.qlik.com/t5/Data-Movement-Streaming/Numeric-value-on-Data-Model-but-Text-in-Sheet-graphs/m-p/2097874#M1282 <P>I have a problem where I am loading the data correctly as a Numeric value as shown in the Data Model tab, but when I will try to use the field in the Sheets tab it formats as Text.</P> <P>Data Model tab:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IgorRibeiroNordica_0-1690462172190.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/113084i198DCAFDF6B2EB27/image-size/medium?v=v2&amp;px=400" role="button" title="IgorRibeiroNordica_0-1690462172190.png" alt="IgorRibeiroNordica_0-1690462172190.png" /></span></P> <P>Sheet tab:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IgorRibeiroNordica_1-1690462223031.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/113085i09C715541F9C3EFB/image-size/medium?v=v2&amp;px=400" role="button" title="IgorRibeiroNordica_1-1690462223031.png" alt="IgorRibeiroNordica_1-1690462223031.png" /></span></P> <P>&nbsp;</P> Wed, 19 Mar 2025 23:02:17 GMT Igor-Ribeiro-Nordica 2025-03-19T23:02:17Z https://community.qlik.com/t5/Data-Movement-Streaming/Numeric-value-on-Data-Model-but-Text-in-Sheet-graphs/m-p/2097874#M1282 <P>I have a problem where I am loading the data correctly as a Numeric value as shown in the Data Model tab, but when I will try to use the field in the Sheets tab it formats as Text.</P> <P>Data Model tab:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IgorRibeiroNordica_0-1690462172190.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/113084i198DCAFDF6B2EB27/image-size/medium?v=v2&amp;px=400" role="button" title="IgorRibeiroNordica_0-1690462172190.png" alt="IgorRibeiroNordica_0-1690462172190.png" /></span></P> <P>Sheet tab:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="IgorRibeiroNordica_1-1690462223031.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/113085i09C715541F9C3EFB/image-size/medium?v=v2&amp;px=400" role="button" title="IgorRibeiroNordica_1-1690462223031.png" alt="IgorRibeiroNordica_1-1690462223031.png" /></span></P> <P>&nbsp;</P> Wed, 19 Mar 2025 23:02:17 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Numeric-value-on-Data-Model-but-Text-in-Sheet-graphs/m-p/2097874#M1282 Igor-Ribeiro-Nordica 2025-03-19T23:02:17Z https://community.qlik.com/t5/Data-Movement-Streaming/Numeric-value-on-Data-Model-but-Text-in-Sheet-graphs/m-p/2097922#M1284 <P>Its not the same view on the matter - all numbers are dual() and have a numeric value and a string-representation of this value which is usually identically but it mustn't be. Within the UI everything showed which isn't a link or image is displayed with their string-representation. You could calculate with it and format it like you want - it will work.</P> Thu, 27 Jul 2023 14:56:02 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Numeric-value-on-Data-Model-but-Text-in-Sheet-graphs/m-p/2097922#M1284 marcus_sommer 2023-07-27T14:56:02Z