topic Generating values to Blank or Null values in a field/column in QlikView

Generating values to Blank or Null values in a field/column

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

I have a field/column called LeaveCode with different values eg(AA, PH, AS) along with blank or null values.

How do I populate or generate values for these blank values so that it can be renamed as WD?

YoussefBelloum — Tue, 22 May 2018 08:45:48 GMT

Hi,

try this on the script:

if(len(trim(LeaveCode))=0,1, LeaveCode) as LeaveCode ==> this insert the value 1 when it is blank or null

you can put whatever you want instead of 1

Anonymous — Tue, 22 May 2018 09:01:57 GMT

Thank you!

YoussefBelloum — Tue, 22 May 2018 09:02:45 GMT

you're welcome, good luck