Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

hi. see again my qvw

Gernan

View solution in original post

13 Replies
Not applicable
Author

hi can you post picture ?

i dont have license to access your qvw

Not applicable
Author

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

recode ref.png

Not applicable
Author

hi.

see my Attached.

Regards

Gernan

Not applicable
Author

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

tresesco
MVP
MVP

May be like attached sample?

Not applicable
Author

hi. see again my qvw

Gernan

Not applicable
Author

Hi sir

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

Sent from Samsung Mobile

Not applicable
Author

check my reply

ill put in a load script.

Not applicable
Author