Cross table in qlik sense

[#1]

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?

Sincerely,

Betty Habtemariam

[sunny_talwar]

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.

For example:

CrossTableLOAD:

CrossTable (Date, Value, 2)

LOAD Dim1,

          Dim2,

          AllDate

From XYZ....

[JonnyPoole]

Correct - no wizard but there is a helpful enablement video to do this in Sense

Power of Qlik Script - Reshaping Data with Crosstable (video)

[reddy-s]

Hi Betty,

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.

[mayuresh_d]

hi,

  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,

Mayuresh