Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
thomas_skariah
Contributor III

Replacing Values

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

Tags (3)
6 Replies
Not applicable

Re: Replacing Values

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

Hi,

Hope the attachment helps.

PFA

senpradip007
Valued Contributor III

Re: Replacing Values

Try this:

PurgeChar(SubDate,'AB')

thomas_skariah
Contributor III

Re: Re: Replacing Values

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

thomas_skariah
Contributor III

Re: Re: Replacing Values

Anyone.any suggestion on this?

Re: Replacing Values

Hi,

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