Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have below table in excel :-
03-Jul-20 | 10-Jul-20 | 17-Jul-20 | 24-Jul-20 | 31-Jul-20 | 07-Aug-20 | 14-Aug-20 | 21-Aug-20 | 28-Aug-20 | 04-Sep-20 | 11-Sep-20 | 18-Sep-20 | 25-Sep-20 | 02-Oct-20 | 09-Oct-20 | 16-Oct-20 | 23-Oct-20 | 30-Oct-20 | 06-Nov-20 | 13-Nov-20 | 20-Nov-20 | 27-Nov-20 | |
BT | 20,866 | 19,271 | 17,238 | 16,618 | 17,962 | 21,160 | 18,956 | 21,940 | 22,942 | 20,911 | 20,772 | 22,562 | 24,221 | 23,999 | 24,655 | 27,032 | 27,335 | 23,870 | 22,297 | 23,038 | 26,060 | 36,520 |
Plusnet | 8,356 | 6,046 | 6,290 | 6,581 | 7,830 | 7,929 | 5,711 | 6,292 | 6,017 | 6,270 | 6,027 | 5,821 | 5,249 | 6,487 | 6,191 | 4,716 | 5,107 | 6,176 | 6,893 | 7,717 | 7,231 | 6,355 |
EE | 7,149 | 6,561 | 6,486 | 6,582 | 6,209 | 5,881 | 5,371 | 5,726 | 6,063 | 5,689 | 6,346 | 5,605 | 5,435 | 5,828 | 5,755 | 4,560 | 4,183 | 4,560 | 4,266 | 4,281 | 3,965 | 3,640 |
I wish to get the output like below :-
Brand, Month Year, Values
BT, jan21, 10
Plusnet, Feb 21, 20
EE, Mar 21, 60
I am trying to do it via crosstable but i am unable to get the output. Can anyone please help ?
Thanks in advance
Hi
Like This
temp:
CROSSTABLE (MonthYear,Value,1)
LOAD
*
FROM [lib://Documents/Copie de TESTCROSS.xlsx]
(ooxml, embedded labels, table is Feuil1);
rename Field F1 to Brand;
As first column don't have label , qlik will add F1 as label for Brand , load as it is first then change the label name from F1 to Brand