Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to update a null

Hello all

I am trying to update few variables using IF, all of them update where there is a value however when there's no value I can't get the query to update the field with a comment.

Can you please help

   LOW_SEG_CDE,
If([LOW_SEG_CDE] ='DD1', 1 Default',
If([LOW_SEG_CDE] ='DD2', '2 Attested',
If([LOW_SEG_CDE] ='DD3', 'BI Default',
If([LOW_SEG_CDE] = 'null', 'Default_Depository',)))) as 'SRP_Marker', 

1 Solution

Accepted Solutions

How about try this

If([LOW_SEG_CDE] ='DD1', 1 Default',
If([LOW_SEG_CDE] ='DD2', '2 Attested',
If([LOW_SEG_CDE] ='DD3', 'BI Default', 'Default_Depository'))) as 'SRP_Marker',

View solution in original post

5 Replies

Hi,

use

isnull(FieldName) or len(trim(FieldName))=0,'Default Depositry'

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

How about try this

If([LOW_SEG_CDE] ='DD1', 1 Default',
If([LOW_SEG_CDE] ='DD2', '2 Attested',
If([LOW_SEG_CDE] ='DD3', 'BI Default', 'Default_Depository'))) as 'SRP_Marker',

View solution in original post

Partner
Partner

Or use an applymap

SRP_Marker:

Mapping Load * Inline [From, To

'DD1', 1 Default',
'DD2', '2 Attested',
'DD3', 'BI Default',

];


Load ...

...
ApplyMap('SRP_Marker',LOW_SEG_CDE,'Default_Depository') as 'SRP_Marker',

....

From

Specialist
Specialist

Hi,

Try below code

f([LOW_SEG_CDE] ='DD1', 1 Default',
If([LOW_SEG_CDE] ='DD2', '2 Attested',
If([LOW_SEG_CDE] ='DD3', 'BI Default',  'Default_Depository',))) as 'SRP_Marker',


Thanks,

Venkata Sreekanth



Contributor III
Contributor III

Thank you all for your help, it was truly appreciated.