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: 
paulyeo11
Master
Master

How to change this table GL CODE to 10026 ?

Hi All

I have import a GL Table into QV .

I want to change all the GL CODE number 10026 , Now it have many other number.

I try :-

if(@1:16T='','10026') as GL_CODE_NEW1,

it does not work , as it return nul value.

Hope some one can advise me.

Paul

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi,

Try below,

If(Len(Trim(@1:16T))=0, '10026') as GL_CODE_NEW1,

View solution in original post

3 Replies
paulyeo11
Master
Master
Author

Enclosed my QV doc

Anonymous
Not applicable

Hi,

Try below,

If(Len(Trim(@1:16T))=0, '10026') as GL_CODE_NEW1,

paulyeo11
Master
Master
Author

thank you work now