Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
If(Len(Trim(@1:16T))=0, '10026') as GL_CODE_NEW1,
Enclosed my QV doc
thank you work now