Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

?

.

1 Reply
marcus_sommer

You need a following load to your crosstable-load which creates an appropriate month-field because values like '1/19' won't match with 'Jan' from the month() function. For this you could use something like this:

...

ForecastFinal:
load *, month(makedate(subfield(Month, '/', 2), subfield(Month, '/', 1)) as MonthNew resident Forecast;

...

- Marcus