Discussion Board for collaboration on QlikView Scripting.
Hi , how can i get only empty value for a filed thanks gidon
Go to Solution.
Then something like this code should work:
Table:LOAD CREDIT, If(Len(Trim(CREDIT)) = 0, 1) AS AA // when CREDIT is null, AA = 1FROM ...
If(Len(Trim(CREDIT)) = 0, 1) AS AA // when CREDIT is null, AA = 1
Hope that helps.
If you mean you want to add an empty value to a field, do as follows in the script:
Table:LOAD Field1, Field2 Null() AS EmptyField, '' AS EmptyField_2FROM ...
Null() AS EmptyField,
'' AS EmptyField_2
if(isnull(fieldName),fieldName) as fieldName
if(fieldName=' ',fieldName) as fieldName
if(len(fieldName)=0' ',fieldName) as fieldName
use above inside scripe
hope this helps
thanks for your prompt answer ,
i have a field name CREDIT , only in some of the recoder this field get a value
i want to define as a new filed AA in the same record if the value of the filed is null
thanks for your promt answer