Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi friends ,
I have a data like this i need to do cross table
can anyone help me with the expression ,
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 |
Benefits | 0 | 0 | 0 | 0 | 0 | 0 |
Total Personnel cost | 0 | 0 | 0 | 0 | 0 | 0 |
Recruitment | 0 | 0 | 0 | 0 | 0 | 0 |
Training | 0 | 0 | 0 | 0 | 0 | 0 |
Other Personnel | 0 | 0 | 0 | 0 | 0 | 0 |
Capitalised labour | 0 | 0 | 0 | 0 | 0 | 0 |
Net Personnel Cost | 0 | 0 | 0 | 0 | 0 | 0 |
Other Cost | 0 | 0 | 0 | 0 | 0 | 0 |
Total Operating Costs | 0 | 0 | 0 | 0 | 0 | 0 |
EBITDA | 49,117 | 49,586 | 73,598 | 52,235 | 42,049 | 53,801 |
EBITDA % | 11% | 12% | 17% | 12% | 10% | 12% |
one example:
tabTemp:
CrossTable(MonthYear,sales)
LOAD * FROM [https://community.qlik.com/t5/New-to-Qlik-Sense/cross-table-load/td-p/1964804] (html, codepage is 1252, embedded labels, table is @1);
tabSales:
LOAD *,
Month(MonthYear) as Month,
Year(MonthYear) as Year;
LOAD F1 as Category,
Date#(MonthYear,'MMM-YY') as MonthYear,
sales
Resident tabTemp;
DROP Table tabTemp;
hope this helps
Marco