topic Issue in loading the data from excel to Qlikview in QlikView https://community.qlik.com/t5/QlikView/Issue-in-loading-the-data-from-excel-to-Qlikview/m-p/585553#M1117342 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I see that the data when imported from excel to qlikview is not of the same data type.In my sample application i have four Metric Values wherein the first three are % values and the fourth metric value represents the number of hours but when I load the excel to qlikview i see that the chart is representing the % values as decimals like 99.99% is shown as 0.99.So can anyone please help me know how I could maintain the original data type present in the excel to be as is in qlikview also.</P><P></P><P>Regards,</P><P>Smitha</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT 2020-11-20T18:02:30Z Issue in loading the data from excel to Qlikview https://community.qlik.com/t5/QlikView/Issue-in-loading-the-data-from-excel-to-Qlikview/m-p/585553#M1117342 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I see that the data when imported from excel to qlikview is not of the same data type.In my sample application i have four Metric Values wherein the first three are % values and the fourth metric value represents the number of hours but when I load the excel to qlikview i see that the chart is representing the % values as decimals like 99.99% is shown as 0.99.So can anyone please help me know how I could maintain the original data type present in the excel to be as is in qlikview also.</P><P></P><P>Regards,</P><P>Smitha</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Issue-in-loading-the-data-from-excel-to-Qlikview/m-p/585553#M1117342 2020-11-20T18:02:30Z Re: Issue in loading the data from excel to Qlikview https://community.qlik.com/t5/QlikView/Issue-in-loading-the-data-from-excel-to-Qlikview/m-p/585554#M1117343 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/53172_pastedImage_0.png" style="width: auto; height: auto;" /></P></BODY></HTML> Fri, 14 Feb 2014 04:25:41 GMT https://community.qlik.com/t5/QlikView/Issue-in-loading-the-data-from-excel-to-Qlikview/m-p/585554#M1117343 iktrayanov 2014-02-14T04:25:41Z Re: Issue in loading the data from excel to Qlikview https://community.qlik.com/t5/QlikView/Issue-in-loading-the-data-from-excel-to-Qlikview/m-p/585555#M1117344 <HTML><HEAD></HEAD><BODY><P>Hi Smitha,</P><P></P><P>Under number option , you can modify your excel values.</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/53175_pastedImage_0.png" style="width: 620px; height: 349px;" /></P><P></P><P></P><P>Thanks,</P><P>AMIT</P></BODY></HTML> Fri, 14 Feb 2014 05:24:30 GMT https://community.qlik.com/t5/QlikView/Issue-in-loading-the-data-from-excel-to-Qlikview/m-p/585555#M1117344 amit_saini 2014-02-14T05:24:30Z