Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Make Column as Month

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 ForecastMar ForecastApril Forecast
May ForecastJun 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

1 Solution

Accepted Solutions

Re: Make Column as Month

Hi Jose,

another solution with some formatting of the source columns:

QlikCommunity_Thread_113589_Pic1.JPG.jpg

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

5 Replies
Not applicable

Re: Make Column as Month

Dear Jose,

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

Regards

Nirmal

MVP
MVP

Re: Make Column as Month

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

Hi Jose,

another solution with some formatting of the source columns:

QlikCommunity_Thread_113589_Pic1.JPG.jpg

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

Please close this thread if your problem is solved.

thanks

regards

Marco

Not applicable

Re: Make Column as Month

Thank you guys, you saved my day!

Community Browser