In the first part I am converting an Pivoted data stored in an Excel into a un pivoted data into QlikView using The Crosstable Load. If you did not get this, then open the link to read more about it.
Income:
CrossTable (MonthYear, Data)
LOAD Income,
[42736],
[42767],
[42795]
FROM .....;
Next, we have the problem that date is read as a number. In fact, the problem is that CrossTable reads all the fields as text. So, 42736, 42767, 42795 are not read as numbers, but text. In order to convert it into number, I have used Num#() function. Now once it is a number, all I needed was a date function to show it as a date, but just to make sure that they are also month start dates, I used MonthStart() function between date() and Num$() functions.
Income_Final:
LOAD Income,
Date(MonthStart(Num#(MonthYear)), 'MM/YYYY') as MonthYear
Data
Resident Income;
DROP Table Income;
Does it help now?
