Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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