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.
Qlikview Consultant Trainee
You could parse the Space values out when loading the fields in the script.
If(Field=" ", 0, Field) as Field
If (B=" ",0, B) as 1stDimension,
If (C=" ",0,C) as 2ndDimension,
If (D=" ", 0, D) as 3rdDimension,
This is not working, What should I do ???
Retrieving data ...