topic Make Column as Month in QlikView

Make Column as Month

Tue, 08 Apr 2014 19:42:55 GMT

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

Re: Make Column as Month

Tue, 08 Apr 2014 20:08:47 GMT

Dear Jose,

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

Regards

Nirmal

Re: Make Column as Month

maxgro — Tue, 08 Apr 2014 20:16:28 GMT

CrossTable (Month, Forecast)

LOAD *

FROM

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

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

Re: Make Column as Month

MarcoWedel — Tue, 08 Apr 2014 23:07:44 GMT

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

Re: Make Column as Month

MarcoWedel — Thu, 24 Apr 2014 08:17:14 GMT

Please close this thread if your problem is solved.

thanks

regards

Marco

Re: Make Column as Month

Thu, 24 Apr 2014 14:38:01 GMT

Thank you guys, you saved my day!