Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Displaying different data types under one column

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

1 Solution

Accepted Solutions
Partner
Partner

AW:Re: Displaying different data types under one column

Hi,

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

8 Replies
Not applicable

Displaying different data types under one column

please send me XLS sheet .

Partner
Partner

AW:Displaying different data types under one column

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

Not applicable

Displaying different data types under one column

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

Not applicable

AW:Displaying different data types under one column

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.

Partner
Partner

AW:Re: Displaying different data types under one column

Hi,

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

Not applicable

AW:Re: Displaying different data types under one column

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.

Not applicable

AW:Re: Displaying different data types under one column

Hi

I attached sample file herewith please refer this.

Regards

Ashish Srivastava

Not applicable

AW:Re: Displaying different data types under one column

Thank you both a lot Big Smile.

Its working perfectly now.

Thanks for your time Yes.