Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Dear Jose,
As of my understood I done the application. Hope it will helps you. Please find the attachement.
Regards
Nirmal
CrossTable (Month, Forecast)
LOAD *
FROM
[http://community.qlik.com/thread/113589]
(html, codepage is 1252, embedded labels, table is @1);
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
Please close this thread if your problem is solved.
thanks
regards
Marco
Thank you guys, you saved my day!