i am reading on Qlikview from an Excel Sheet but i am facing a problem.
how can i fill an empty Cell ex:
A B C
When i Importing this Form the first cell in column B and C is empty
the script will show like this
i need to show as
Ps: i cannot change in the form of the excel sheet cause i have almost a hundred excel sheet same form so if i change one i have to change the others so it will take alot of time, i am looking for a solution using Qlikview,