topic Re: Data replace in listbox in QlikView

Data replace in listbox

Mon, 15 Jun 2015 16:41:35 GMT

Dear All,

I need to delete or replace the collon(') symbol in listbox, please find attached snapshot for the same.

In the screenshot, the data in red lined box contains ' symbol at the end. I dont want to load the data which has ' symbol. How can I ignore/delete the first two rows of data in the attached screenshot.

How can I do this, please help me....

Thanks,

Ananth

Re: Data replace in listbox

sunny_talwar — Mon, 15 Jun 2015 16:45:52 GMT

From the Field drop down, select Expression:

And use the expression: =Replace(BUSINESS_UNIT_ID, Chr(39), '')

Re: Data replace in listbox

Colin-Albert — Mon, 15 Jun 2015 16:52:15 GMT

There are various functions that can cleanse your data

replace(); keepchar(); purgechar()

It is best to do this in the script rather than in the front-end listbox.

Try purgechar(BUSINESS_UNIT_ID, chr(39))

Re: Data replace in listbox

Mon, 15 Jun 2015 16:59:55 GMT

Thanks for your quick responce.

I tried in script like

purgechar(BUSSINESS_UNIT_ID,Chr(39)) as BusinessID,

it gave me field not found error

Re: Data replace in listbox

Anonymous — Mon, 15 Jun 2015 17:03:46 GMT

Did you place the call in the same tables script? the field name should be the exact same name as the one in your screenshot.

Re: Data replace in listbox

sunny_talwar — Mon, 15 Jun 2015 17:04:19 GMT

I just tried this script:

Table:

LOAD PurgeChar(Name, Chr(39)) as Name;

LOAD * Inline [

Name

A'Souza

];

Did not give any problem. Are you sure you are using the field name BUSSINESS_UNIT_ID correctly? Can you share the table where you are doing this in the script?

Best,

Sunny

Re: Data replace in listbox

Mon, 15 Jun 2015 17:11:27 GMT

Thank you all, i got my answer.

thanks community

Re: Data replace in listbox

Colin-Albert — Mon, 15 Jun 2015 17:13:47 GMT

Is the field name correct? is is BUSSINESS_UNIT_ID or BUSINESS_UNIT_ID