topic Re: how to get required data form different criteria? in QlikView

how to get required data form different criteria?

Fri, 24 Jul 2015 04:42:46 GMT

Dear Experts,

In my description column, I would like to pick up the ref no: but these are not the same format. I would like to know how to get the required ref: no?

Best Regards,

Kyaw Myo Tun

Re: how to get required data form different criteria?

qlikmsg4u — Fri, 24 Jul 2015 04:53:19 GMT

Hi Kyaw,

Try this

LOAD Date,

ID,

DESCRIPTION,

AMOUNT,

F5,

KeepChar(DESCRIPTION,'0123456789') as [NEW DESCRIPTION]

FROM Source;

Re: how to get required data form different criteria?

Fri, 24 Jul 2015 05:06:30 GMT

Dear K N,

it work well for the situation but I made a mistake in my excel. The ref no: is not only contain digit but also character. (eg....13050ABC1002). how can i get that data?

Best Regards,

Kyaw Myo Tun

Re: how to get required data form different criteria?

qlikmsg4u — Fri, 24 Jul 2015 05:09:57 GMT

Please post sample data containing mixed text

Re: how to get required data form different criteria?

Fri, 24 Jul 2015 05:17:35 GMT

Dear K N,

Best Regards,

Kyaw Myo Tun

Re: how to get required data form different criteria?

qlikmsg4u — Fri, 24 Jul 2015 05:23:18 GMT

I tried something like this, but this may not the feasible solution and also it will fail if there were symbols other than the used ones in script, i will look into some more solutions

LOAD Date,

ID,

DESCRIPTION,

AMOUNT,

F5,

Subfield(Replace(DESCRIPTION,':','-'),'-',2) as [NEW DESCRIPTION]

FROM

Source

Re: how to get required data form different criteria?

Fri, 24 Jul 2015 05:24:24 GMT

Hi,

This will help u to complete u r task.

keepchar is a string function it will help to separate text and string values

KeepChar(DESCRIPTION,'0123456789') as Newdata

Thanks and regards,

Balaji.k

Re: how to get required data form different criteria?

Fri, 24 Jul 2015 05:33:36 GMT

Dear K N,

It work correctly for my purpose. Thanks for your help.

Best Regards,

Kyaw Myo Tun