Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

How to filter QTR as T and QTK as K ?

Hi All

I have a field name for quotation ref , the format is xx/QTK/xx , i like to filter when QTR it will filter as R and QTK as K. take note that first 2 number some time 2 charater some time 3 charater.

1 Solution

Accepted Solutions
Not applicable

Re: Re: Re: Re: How to filter QTR as T and QTK as K ?

hi. see again my qvw

Gernan

13 Replies
Not applicable

Re: How to filter QTR as T and QTK as K ?

hi can you post picture ?

i dont have license to access your qvw

Not applicable

Re: How to filter QTR as T and QTK as K ?

Hi Sir , Take note of the first 2 and 3 charater. 

recode ref.png

Not applicable

Re: Re: How to filter QTR as T and QTK as K ?

hi.

see my Attached.

Regards

Gernan

Not applicable

Re: Re: Re: How to filter QTR as T and QTK as K ?

Hi Sir

Now my issue is how to add your expression onto my existing script which is already working fine. This is because my script is unlike like you . which is able to read the particular field and record from there , for mine is i need to read all field , and i am not sure how to do partial reload for create the new filed which recode the ref no to sales man name.

Paul

MVP
MVP

Re: How to filter QTR as T and QTK as K ?

May be like attached sample?

Not applicable

Re: Re: Re: Re: How to filter QTR as T and QTK as K ?

hi. see again my qvw

Gernan

Not applicable

Re: How to filter QTR as T and QTK as K ?

Hi sir

Thank you for your sharing. But what I need is do this at load script.

Sent from Samsung Mobile

Not applicable

Re: How to filter QTR as T and QTK as K ?

check my reply

ill put in a load script.

Not applicable

Re: How to filter QTR as T and QTK as K ?