Null or Zero

[gaurav2017]

Hi folks,

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

A	B	C	D
P	100	50	0
Q	100	50
R	100	0	0
S	100

So the problem is:

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

Regards,

Gaurav Malhotra

Qlikview Consultant Trainee

[Anonymous]

Hi Gaurav,

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

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

[gaurav2017]

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 ???