Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Cross table in 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?

Sincerely,

Betty Habtemariam

4 Replies

Re: Cross table in qlik sense

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....

Employee
Employee

Re: Cross table in qlik sense

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

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

reddys310
Honored Contributor II

Re: Cross table in qlik sense

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
Contributor

Re: Cross table in qlik sense

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