topic Re: Show only numbers in QlikView

Show only numbers

Wed, 22 Jul 2015 13:01:27 GMT

Hi All

I have field with values both numbers and text but I want to show only numbers from that.

How can I achieve the same.

Thanks for the help

Re: Show only numbers

Kushal_Chawda — Wed, 22 Jul 2015 13:02:17 GMT

Try,

Keepchar(Name,'0123456789')

Re: Show only numbers

sunny_talwar — Wed, 22 Jul 2015 13:02:40 GMT

Use this as your expression: =If(IsNum(Field), Field)

Re: Show only numbers

Wed, 22 Jul 2015 13:07:17 GMT

Hi ,

I am getting blank values while I am using this

Re: Show only numbers

Wed, 22 Jul 2015 13:07:53 GMT

Hi,

It works. let me test it completely

Re: Show only numbers

awhitfield — Wed, 22 Jul 2015 13:08:44 GMT

Can you post some sample data / script details?

Andy

Re: Show only numbers

sunny_talwar — Wed, 22 Jul 2015 13:09:01 GMT

I think Kush141087‌ understood your requirement better than I did.

Re: Show only numbers

Kushal_Chawda — Wed, 22 Jul 2015 13:18:06 GMT

hey sunindia i think question was not structured well.Field values have both numbers and text means you understood correctly. May be i did not understand properly but may be i will lucky

Re: Show only numbers

sgrice — Wed, 22 Jul 2015 13:23:55 GMT

ALT(Field)

Re: Show only numbers

krishna20 — Wed, 22 Jul 2015 13:29:28 GMT

HI,

Try this

=purgeChar(Data,'()ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')

Find the sample also.

Re: Show only numbers

sasiparupudi1 — Wed, 22 Jul 2015 13:38:10 GMT

Your solution wouldnt work if the data contains special characters like & @

ex: &A1234

where as keepChar('&A1234','0123456789') would always keep only the numbers in a string

Re: Show only numbers

Wed, 22 Jul 2015 17:48:56 GMT

Sorry for not explained well. I have field values like.. abc123, abc, xyz1234, xyz etc...

Need to create two fields as Number and Name

Required o/p

Number - 123,1234

Name- abc,xyz

Re: Show only numbers

Wed, 22 Jul 2015 17:49:50 GMT

Sorry for not explained well. I have field values like.. abc123, abc, xyz1234, xyz etc...

Need to create two fields as Number and Name

Required o/p

Number - 123,1234

Name- abc,xyz

Re: Show only numbers

sunny_talwar — Wed, 22 Jul 2015 17:51:12 GMT

Try this:

LOAD *

KeepChar(FieldName, '0123456789') as Number

PurgeChar(FieldName, '0123456789') as Name

Resident xyz;

Re: Show only numbers

Wed, 22 Jul 2015 17:57:20 GMT

thanks sunny