Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Gaurav,
You could parse the Space values out when loading the fields in the script.
If(Field=" ", 0, Field) as Field
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 ???