Discussion board where members can get started with Qlik Sense.
I would like to do a crosstable.
May I know how to do that?
I found an old post about this. Check: https://community.qlik.com/t5/QlikView-App-Development/crosstable-reversed/td-p/446395
Try like below.
thanks for reply.
However, it doesn't work.
table:Load *from tablename;
NoConcatenatet:LoadID,Num(Date#(Week, 'DD/MM/YYYY')) as Week,CostResident table;
drop Table table;
LOAD DISTINCT ID RESIDENT t;
DROP TABLE t;
FOR i = 0 to NoOfTables()
LOAD TableName($(i)) AS Tablename AUTOGENERATE 1
WHERE WildMatch(TableName($(i)), 't1.*');
FOR i = 1 to FieldValueCount('Tablename')
LET vTable = FieldValue('Tablename', $(i));
LEFT JOIN (t2)LOAD *RESIDENT $(vTable);
DROP TABLE $(vTable);
DROP Table t3;
you want to do this in a chart?
Create pivot table
select ID as dimension
select Week as column
use sum(Cost) as expression