topic Re: How to update a null in QlikView

How to update a null

mohiahmed — Wed, 25 Nov 2020 16:16:04 GMT

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',

Re: How to update a null

PrashantSangle — Wed, 14 Mar 2018 13:01:38 GMT

Hi,

use

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

Regards

Re: How to update a null

sunny_talwar — Wed, 14 Mar 2018 13:02:18 GMT

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',

Re: How to update a null

stigchel — Wed, 14 Mar 2018 13:08:02 GMT

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

Re: How to update a null

Anonymous — Wed, 14 Mar 2018 14:17:53 GMT

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

Re: How to update a null

mohiahmed — Wed, 14 Mar 2018 14:20:53 GMT

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