topic Re: Re: Replacing Values in QlikView

Replacing Values

thomas_skariah — Thu, 19 Sep 2013 10:07:28 GMT

Hi All,

Can anyone suggest how i can achieve the following scenario in which there are three columns Ref,SubDate and Amount.

(Please find the attached screen shot). Here there are Ref 300 & 300A (300 with suffix A) I have to replace the SubDate of 300A with that of Subdate of 300 and then have to exlcude the entire record of ref 300 from the table.Similarly Subdate of ref 600B should be replaced with 600 and have to exclude both 600 and 600A from the table..This logic should should be applicable to all Ref with suffix (A or B).

Thanks in advance.

Regards,

Tom

Re: Replacing Values

Thu, 19 Sep 2013 11:00:11 GMT

Hi Tom

I believe you are looking for something like the below if I have understood correctly.

If I am right, can you mark the answer as correct, or let me know if I have missed the mark,

Regards

Steve

Re: Replacing Values

CELAMBARASAN — Thu, 19 Sep 2013 12:34:11 GMT

Hi,

Hope the attachment helps.

PFA

Re: Replacing Values

senpradip007 — Thu, 19 Sep 2013 12:42:06 GMT

Try this:

PurgeChar(SubDate,'AB')

Re: Re: Replacing Values

thomas_skariah — Sun, 22 Sep 2013 08:15:19 GMT

Hi Steve,

Sorry for late reply.Here I don't want the Ref with suffix to be removed.Please find the attached image.

Regards,

Tom

Re: Re: Replacing Values

thomas_skariah — Mon, 23 Sep 2013 05:25:06 GMT

Anyone.any suggestion on this?

Re: Replacing Values

CELAMBARASAN — Mon, 23 Sep 2013 11:41:28 GMT

Hi,

Did you have a look at my attachment of my previous reply?