Cross table Load

[srikanth1994]

Hi Qlik Learners

I have data like this when i applied cross table function the month column is showing as below number my concern is i need to show month name and year please help me i am new to Qlik sense.

 "43466",
"43497",
"43525",
"43556",
"43586",
"43617",

Data only
	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19
Revenue	433,103	416,756	424,787	424,457	441,999	439,205
COS	383,986	367,170	351,189	372,222	399,951	385,404
Customer Access & Backbone cost	291,149	270,956	264,859	272,044	298,574	289,660
Remaining access cost	3,753	1,068	(0)	1,109	597	6
Colocation cost	74,855	71,191	62,580	77,787	76,696	73,359
Other NS cost	14,229	23,955	23,750	21,282	24,084	22,378
Market Prizm	0	0	0	0	0	0
Asset Sale	0	0	0	0	0	0
Contribution	49,117	49,586	73,598	52,235	42,049	53,801
Contribution %	11%	12%	17%	12%	10%	12%
TLC	0	0	0	0	0	0
Base Pay	0	0	0	0	0	0
Annual Bonus	0	0	0	0	0	0
Commissions	0	0	0	0	0	0

[PrashantSangle]

Can you share your script? you have to use date() or Monthname()

[srikanth1994]

CrossTable(Month,sales)
LOAD
"Data only",
"43466",
"43497",
"43525",
"43556",
"43586",
"43617"
FROM [lib://GetLink (internal_jmehra)/Copy of Dummy Numbers for NIPA.xlsx]
(ooxml, embedded labels, header is 4 lines, table is Dummy);

[MarcoWedel]

You could try with a subsequent resident load to correct the Month format.

[PrashantSangle]

Hello Srikanth,

Simplest way is you can alise them like ,

LOAD
"Data only",
"43466" as "Jan 19",
"43497" as "Feb 19",
"43525" as "Mar 19",
"43556" as "Apr 19",
"43586" as "May 19",
"43617" as "Jun 19"

or as Marco suggested do load of the data, then apply monthName() on that date field & use resident load for cross Table

Regards,

Prashant Sangle