Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

field null

hi,

i have a select sql and a field cointains a value null.

I create a table

LOAD * INLINE [

Num, Name

" ", Jenny

2, Febrizio

3, Mark

and the column Num is joined to another field NumId

The problem is the missing of data when I use a pivot table

5 Replies

Re: field null

You can associate any other value (say 999) whenver Num is blank or null. Use below in script

Load

     If(IsNull(Num) or Len(Trim(Num))=0, 999, Num) as Num,

     Name

From....

Not applicable

Re: field null

Try this.

Table:

LOAD * INLINE[

  If(IsNull(Num),'null',Num) as Num,,Name

" ",Jenny

2,Febrizo

3,Mark

];

fmazzarelli
Contributor III

Re: field null

hi,

it seems all correct but when i create a bar chart, i have this misalignment.

The value null ... has a bar on his own.

and the name ... hasn't values

Immagine.png

fmazzarelli
Contributor III

Re: field null

hi,

Solved

My starting field was 5 (value null)

ahi ahi ahii

evandro_segura
New Contributor III

Re: field null

Boa tarde Fábio

Como ele faz parte da chave, no script ETL sugiro que atribua 0 (zero) ao campo caso seja nulo.

Algo assim: LOAD ..., If(IsNull(Num), 0, Num) As %NumID

Community Browser