Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
xyz1
Contributor III

?

.

1 Reply
MVP & Luminary
MVP & Luminary

Re: Concatenate cross table with field name as "month name"

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