Solved: Re: Ques - Qlik Community

Dolly123 · ‎2022-02-23

I have spaces here I want to fill the word , nulls or fill with 0(zero)

micheledenardi · ‎2022-02-28

try this:

Load *,
  if(isnull([Liquid Sub]) or trim([Liquid Sub])='',0,[Liquid Sub]) as [Liquid Sub New]
From YourDataSource;

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

micheledenardi · ‎2022-02-28

try this:

Load *,
  if(isnull([Liquid Sub]) or trim([Liquid Sub])='',0,[Liquid Sub]) as [Liquid Sub New]
From YourDataSource;

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

micheledenardi · ‎2022-02-28

When applicable, please mark the answer as Correct.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.