topic How to remove 7 in that in QlikView

How to remove 7 in that

kulasekhar — Fri, 17 Apr 2015 09:37:36 GMT

Hi All,

Load the following data into qlikview:

LOAD * INLINE[
F1

1234567

1234576

1234756

1237456

1273456

1723456

7123456

];

Need to filter the data where the values contain the digit ‘7’ in data above.

(remove 7 in that)

So output should be :

---------------

123456

Thanks,

sekhar

Re: How to remove 7 in that

Anonymous — Fri, 17 Apr 2015 09:45:31 GMT

Hi,

Try

Replace(F1,7,'')

Regards,

Greeshma

Re: How to remove 7 in that

rubenmarin — Fri, 17 Apr 2015 09:47:22 GMT

Hi Sekhar, you can use Purgechar():

LOAD PurgeChar(F1, '7') as F1;

LOAD * INLINE [

1234567

1234576

1234756

1237456

1273456

1723456

7123456

];

Re: How to remove 7 in that

kulasekhar — Fri, 17 Apr 2015 09:53:18 GMT

Hi Ruben,

result display only one row.like 123456

Thanks

sekhar

Re: How to remove 7 in that

rubenmarin — Fri, 17 Apr 2015 09:56:40 GMT

Hi Sekhar, there are many records with the same value, in a list box will show as only one value, if you add some another distinct field like "RowNo() as Number", and create a table box with those two fields, you'll see all records separated.

Re: How to remove 7 in that

kulasekhar — Fri, 17 Apr 2015 10:00:18 GMT

THanks

Ruben