file transformation issue - Qlik Community

bushpalaamarnat · ‎2018-09-17

the file does not have decimal values in excel but when loaded into qlikview the file is changing the values into decimal of 6 digits.

could you please help?

Anil_Babu_Samineni · ‎2018-09-18

In excel Number format is in which? Could be decimal is there in the list from Excel it self. Because .000 never consider in Excel where as Qlik can. Instead, After that you can use Num() to remove decimal if you really don't need

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

bushpalaamarnat · ‎2018-09-18

‌the excel does not have decimal valu. Also, this problem started from when I started using transformation where I removed the rows which have empty values in colume 1.

WHy why do you think that is happening.

YEs, am aware of the process of loading data as number(). Was interested ti know about the other options sir.

marcus_sommer · ‎2018-09-18

Are you sure that there no decimal-digits? That Excel don't show one doesn't mean mandatory that there are no one.

Further what happens if you load the data - are there any digits on your values? Maybe it's just a feature of the advanced possibilities of the file wizard.

- Marcus