Displaying different data types under one column

[#1]

I am loading data from an xls. It has some columns that need to represent both integer values as well as percentage values. For example, it has values as follows;

456,766

34,566

26%

17.5%

When I load them into Qlikview onto a pivot table, I either get all integer values or all percentage values.

There have been previous posts and I have tried the solution but they have not worked for me.

I have also tried the following steps

- Document properities

- Numbers tab

- Mark the field in question

- Uncheck "Survive reload"

- Reload the document

but it does not work, and the first time I tried it the entire pivot table got cleared.

Can someone please advise me on what to do?

Thanks

[#2]

please send me XLS sheet .

[brenner_martina]

Hi,

best you enter an it-then-else condition using the function num, p.e.

If(field<0,Num(field,'0.0%'),Num(field,'#,##0'))

[#4]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/674/2287.testing-file.xlsx:550:0]

Hi,

Ashish, I have attached a downsized version of the file.

Thanks,

[#5]

Hi,

Thanks for your reply Martina. I tried your suggestion, but its showing integers and where the values shouls in percent are showing as zeros.

Pls advise.

[brenner_martina · Accepted solution]

Hi,

that's what I mean! You have to enter at the tab numbers the formula standard!

[#7]

Hi,

Thanks Martina it's working but when I tried it on my own workpage, instead of for example 26% it shows 2.6%.

How can i solve this?

Thanks.

[#8]

Hi

I attached sample file herewith please refer this.

Regards

Ashish Srivastava

[#9]

Thank you both a lot .

Its working perfectly now.

Thanks for your time .