Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

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
satyadev_j
Valued Contributor

Re: How to change this table GL CODE to 10026 ?

Hi,

Try below,

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

3 Replies
paulyeo11
Valued Contributor II

Re: How to change this table GL CODE to 10026 ?

Enclosed my QV doc

satyadev_j
Valued Contributor

Re: How to change this table GL CODE to 10026 ?

Hi,

Try below,

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

paulyeo11
Valued Contributor II

Re: How to change this table GL CODE to 10026 ?

thank you work now

Community Browser