topic AW:Re: Displaying different data types under one column in QlikView

Displaying different data types under one column

Fri, 20 Nov 2020 18:02:30 GMT

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

Displaying different data types under one column

Mon, 23 Aug 2010 07:56:44 GMT

please send me XLS sheet .

AW:Displaying different data types under one column

brenner_martina — Mon, 23 Aug 2010 07:58:01 GMT

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'))

Displaying different data types under one column

Mon, 23 Aug 2010 08:09:16 GMT

[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,

AW:Displaying different data types under one column

Mon, 23 Aug 2010 08:12:01 GMT

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.

AW:Re: Displaying different data types under one column

brenner_martina — Mon, 23 Aug 2010 08:14:05 GMT

Hi,

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

AW:Re: Displaying different data types under one column

Mon, 23 Aug 2010 08:39:20 GMT

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.

AW:Re: Displaying different data types under one column

Mon, 23 Aug 2010 08:44:24 GMT

I attached sample file herewith please refer this.

Regards

Ashish Srivastava

AW:Re: Displaying different data types under one column

Mon, 23 Aug 2010 08:58:38 GMT

Thank you both a lot .

Its working perfectly now.

Thanks for your time .