Discussion board where members can get started with Qlik Sense.
Good day everyone,
Does anyone know if it's possible to do a cross table in qlik sense? If not, is there a similar way to present the data?
I am sure it is possible, although I am sure if there is a crosstable wizard available. You might just need to code it without the wizard.
CrossTable (Date, Value, 2)
Correct - no wizard but there is a helpful enablement video to do this in Sense
Power of Qlik Script - Reshaping Data with Crosstable (video)
As Sunny mentioned you need to either code it with out the wizard or you can generate the script in QlikView and paste the code into QlikSense. This will work too.
You Are right
in qliksense you dont have any crosstable wizard but u can use following syntax,
"crosstable (attribute field name, data field name , n ) ( loadstatement | selectstatement )"
where n is the number columns which are already in the form of fields
thanks and regards,