Uploading data using crosstable in qliksense

Aspiring_Developer — Tue, 21 Jun 2022 08:17:45 GMT

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

Re: Uploading data using crosstable in qliksense

brunobertels — Tue, 21 Jun 2022 14:28:50 GMT

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

topic Re: Uploading data using crosstable in qliksense in App Development

Uploading data using crosstable in qliksense

Re: Uploading data using crosstable in qliksense