topic Re: Excel Sheet Data Loading Issue in QlikView

Excel Sheet Data Loading Issue

Anonymous — Thu, 20 Aug 2015 12:22:48 GMT

Hi,

I am loading excel sheet having % and Number Values in Same field After loading number values are also converted into %.How to resolve this I want excel sheet values exactly Number and % values in same field as in excel.

Please Find the attached Sample excel sheet

Please help me ..

Thanks,

Anusha K

Re: Excel Sheet Data Loading Issue

pokassov — Thu, 20 Aug 2015 12:26:06 GMT

Hi!

num(your_field) as your_field

Re: Excel Sheet Data Loading Issue

Kushal_Chawda — Thu, 20 Aug 2015 12:29:24 GMT

Try loading Field as Text(Field) as Field and then using Num#( Field ..) you can separate the % and Number

Re: Excel Sheet Data Loading Issue

Thu, 20 Aug 2015 12:31:12 GMT

Hi Can you add the sample data

Re: Excel Sheet Data Loading Issue

Anonymous — Thu, 20 Aug 2015 12:34:56 GMT

Just now added the sample excel.PFA

Re: Excel Sheet Data Loading Issue

Anonymous — Thu, 20 Aug 2015 12:44:43 GMT

If we give Num function. entire field will convert to number format.I want to be display as it is as excel

Re: Excel Sheet Data Loading Issue

Kushal_Chawda — Thu, 20 Aug 2015 12:46:42 GMT

Do you want to sow the data as it is or further computation will be done?

Re: Excel Sheet Data Loading Issue

sundarakumar — Thu, 20 Aug 2015 12:51:19 GMT

The data is not in the correct format in the excel. For two rows it is number and for others it is percentage.

This should be the problem.

Regards,

Sundar

Re: Excel Sheet Data Loading Issue

Anonymous — Thu, 20 Aug 2015 12:54:19 GMT

Thanks all for responses . I got the result.

Re: Excel Sheet Data Loading Issue

Kushal_Chawda — Thu, 20 Aug 2015 12:55:49 GMT

So tell us what have you done and mark it as correct answer so that if anyone is facing the same issue will help to resolve the problem