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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issue in loading the data from excel to Qlikview

Hi,

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.

Regards,

Smitha

2 Replies
iktrayanov
Creator III
Creator III

amit_saini
Master III
Master III

Hi Smitha,

Under number option , you can modify your excel values.

Thanks,

AMIT