topic Re: mapping load for checkng null values in QlikView

mapping load for checkng null values

Anonymous — Fri, 30 Jun 2017 12:13:34 GMT

i have a field(x) which has some null values against (y)

so i want to do a mapping load where i need to check the 0 values

so wherever is 0 it shud consider it as null so the value displayed in field y shud be correct

how to do that.

Re: mapping load for checkng null values

prieper — Fri, 30 Jun 2017 13:06:24 GMT

Why do you want to make a mapping?
would do right away in the script:

...
IF(LEN(TRIM(x)) OR x=0, NULL(), y)              AS y_corrected
...

HTH Peter

Re: mapping load for checkng null values

Anonymous — Fri, 30 Jun 2017 14:26:10 GMT

its not working

Re: mapping load for checkng null values

juan_patrick — Fri, 30 Jun 2017 14:36:16 GMT

You can put 0 to null values:

if(isnull(x), 0, x) as field_x,

After that you know that all zero values are the same.

Re: mapping load for checkng null values

vishsaggi — Fri, 30 Jun 2017 14:38:02 GMT

Can you share some sample data here with few rows? Your expected output?

Re: mapping load for checkng null values

effinty2112 — Fri, 30 Jun 2017 14:42:19 GMT

Dear Dynamic Girl,

Do you mean if x is null then treat as if it is zero?

try Alt(x,0) either in script or in a chart expression.

Alt(x,0) will return x if it is numeric and will return 0 if non-numeric (including null).

Kind regards

Andrew

Re: mapping load for checkng null values

el_aprendiz111 — Fri, 30 Jun 2017 15:08:24 GMT

Hi,

options:

IF(FieldX ='', 0, FieldX) AS FieldXNew

IF(FieldX =null(), 0, FieldX) AS FieldXNew

IF(isnull(FieldX), 0, FieldX) AS FieldXNew

Re: mapping load for checkng null values

Anonymous — Sun, 02 Jul 2017 16:42:37 GMT

X and y are fields in difrnt tables,actly we are showing count(distinct x) and y field has 4 values ,say count(distinct x ) is Shwng 40 value but if I select all the 4 values in y field so the count is around 35 so there is a difrnce in values ,we are assuming there is some 0 values against this,so wat I want to try replace all 0 with nulls only

Re: mapping load for checkng null values

Anonymous — Sun, 02 Jul 2017 16:43:27 GMT

X and y are in different tables ,are joined wth left join

Re: mapping load for checkng null values

passionate — Sun, 02 Jul 2017 16:46:58 GMT

Provide some sample data