Make Column as Month

[#1]

Hi all,

I am currently importing an excel file with the following format,

I would like to know if there is a way to make Qlikview consider the whole column as the month represented.

Account Number	Jan Forecast	Feb Forecast	Mar Forecast	April Forecast	May Forecast	Jun Forecast
12837124	$18293	$23523	$21342	$32452	$33252	$34231
34580933	$92083	$23523	$23523	$32563	$33553	$24325
38902490	$90832	$43653	$23523	$54457	$56432	$66431
19283233	$23523	$45633	$34747	$33569	$45644	$57743
39284912	$23552	$34634	$34534	$34643	$35324	$56721

Thank you very much in advance.

Regards

[#2]

Dear Jose,

  As of my understood I done the application. Hope it will helps you. Please find the attachement.

Regards

Nirmal

[maxgro]

CrossTable (Month, Forecast)

LOAD *

FROM

[http://community.qlik.com/thread/113589]

(html, codepage is 1252, embedded labels, table is @1);

[MarcoWedel · Accepted solution]

Hi Jose,

another solution with some formatting of the source columns:

tabData:
CrossTable (MonthTemp, ForecastTemp)
LOAD * FROM [http://community.qlik.com/thread/113589]
(html, codepage is 1252, embedded labels, table is @1);

Left Join
LOAD Distinct
  [Account Number],
  MonthTemp,
  Date#(Left(MonthTemp, 3), 'MMM') as Month,
  ForecastTemp,
  Money(Money#(ForecastTemp, '$#0'), '$ #,##0') as Forecast
Resident tabData;

DROP Fields MonthTemp, ForecastTemp;

hope this helps

regards

Marco

[MarcoWedel]

Please close this thread if your problem is solved.

thanks

regards

Marco

[#6]

Thank you guys, you saved my day!