Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

Hi,

Try below,

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

View solution in original post

3 Replies
Highlighted
Master
Master

Enclosed my QV doc

Highlighted
Specialist
Specialist

Hi,

Try below,

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

View solution in original post

Highlighted
Master
Master

thank you work now