Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
alejortizp
Contributor III
Contributor III

How complete empty values?

Good day,

I am trying to fill the empty values with "Sin Datos" in the senteces of the main script SET NULLINTERPRET="Sin Datos"; or SET NULLDISPLAY="SIN DATO"; but still appearing empty values.

Thanks if you give me a light.

Labels (1)
1 Solution

Accepted Solutions
PabloTrevisan
Partner - Creator II
Partner - Creator II

Try in script

NULLASVALUE *;

set NullValue='SIN DATO';

View solution in original post

6 Replies
PabloTrevisan
Partner - Creator II
Partner - Creator II

Hi Alejandro.

NULLASVALUE yourfield;

set NullValue='SIN DATO';

alejortizp
Contributor III
Contributor III
Author

Hi pablo,

I dont know why doesnt work. That sentences is in the extraccion or the transformation?

This is my code:

EXTRACCION SCRIPT:

[usuarios]:

NULLASVALUE Regional;

set NullValue='SIN DATO';

LOAD

[Código de municipio de residencia del usuario] ,

[Descripción Mpio],

[Regional],

    [Año de reporte],

[Identificación BDUA del usuario],

[Costo total anual de la  prestación de servicios al usuario.]

FROM [lib://Ejercicio antioquia con georeferenciacion/usuarios costosos.xlsx]

Store usuarios into Lib://qvdsmapa/municipioantioquia.qvd;

TRANSFORMATION SCRIPT:

usuarios:

NullAsValue Regional;

set NullValue='SIN DATO';

LOAD

    "Código de municipio de residencia del usuario",

    "Descripción Mpio",

    Regional,

    "Año de reporte",

    "Identificación BDUA del usuario",

    "Costo total anual de la  prestación de servicios al usuario."

FROM [lib://qvdsmapa/usuarios.qvd]

(qvd);

PabloTrevisan
Partner - Creator II
Partner - Creator II

Could You send me your .qvf and a small .qvd to test ?

alejortizp
Contributor III
Contributor III
Author

Hi Pablo,

This is a sample file in which there is a sheet with a bar graph and in the script is the code that I used. Thank you very much if you help me to complete the null values with any field that I specify.

PabloTrevisan
Partner - Creator II
Partner - Creator II

Honestly, it seems to me that it's rubbish in the base, since there is nothing besides the 'cost' in this line where the fields are null, isn't really working ... but is it interesting to go back this line?

PabloTrevisan
Partner - Creator II
Partner - Creator II

Try in script

NULLASVALUE *;

set NullValue='SIN DATO';