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: 
gaurav2017
Creator II
Creator II

Null or Zero

Hi folks,

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

ABCD
P100500
Q10050
R10000
S100

So the problem is:

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

Regards,

Gaurav Malhotra

Qlikview Consultant Trainee

2 Replies
Anonymous
Not applicable

Hi Gaurav,

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

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

gaurav2017
Creator II
Creator II
Author

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