Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator 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
MK_QSL
MVP
MVP

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

Try this.

Table:

LOAD * INLINE[

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

" ",Jenny

2,Febrizo

3,Mark

];

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

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
Partner - Creator III
Partner - Creator III
Author

hi,

Solved

My starting field was 5 (value null)

ahi ahi ahii

Anonymous
Not applicable

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