topic Null or Zero in QlikView

Null or Zero

gaurav2017 — Thu, 21 Jun 2012 05:15:58 GMT

Hi folks,

I was loading some data from excel file something like this:

So the problem is:

I want to treat " " value as "0" in order to make a calculation.

Regards,

Gaurav Malhotra

Qlikview Consultant Trainee

Anonymous — Thu, 21 Jun 2012 05:45:15 GMT

Hi Gaurav,

You could parse the Space values out when loading the fields in the script.

If(Field=" ", 0, Field) as Field

gaurav2017 — Thu, 21 Jun 2012 06:42:29 GMT

LOAD A,

If (B=" ",0, B) as 1stDimension,

If (C=" ",0,C) as 2ndDimension,

If (D=" ", 0, D) as 3rdDimension,

FROM

Temp;

This is not working, What should I do ???