Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cross tables

Hi All

I love the new format of QlicSense, and look forward to using it.  I have been using the CrossTable report format quite intensively in Version 11, but now I cannot find out how to create such tables in QS.  Ie, it should create the 'PivotTable' output of Excel. Any suggestions?

So,  want a table that looks like this:

City      Q1    Q2    Q3

Sydney  23    43    42

Durban  78    21    39

This should be generated from a table with fields"City", "Quarter", "Sales"

Regards

Danie Wium

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Daniel,

For importing Crosstables:

The Crosstable file wizard does not exist at this time for version 0.96, but the Crosstable command is compatible in the Qlik Sense script editor.  For the time being, you can copy and paste your Crosstable script from QlikView 11 to Sense, and it should load with no problems.

For presenting Crosstables:

The solution that Miguel Angel Baeyens presented using the IF() condition for each measure in a table object will work.  Another alternative is using set analysis if you want your table to not be affected by what the user selects in the quarter field.

Cheers,

Sean

View solution in original post

4 Replies
Miguel_Angel_Baeyens

Hi Daniel,

You can always use the table object in Qlik Sense then use a condition with If() for example to get each quarter in its own column.

Miguel

Anonymous
Not applicable
Author

Hi Daniel,

For importing Crosstables:

The Crosstable file wizard does not exist at this time for version 0.96, but the Crosstable command is compatible in the Qlik Sense script editor.  For the time being, you can copy and paste your Crosstable script from QlikView 11 to Sense, and it should load with no problems.

For presenting Crosstables:

The solution that Miguel Angel Baeyens presented using the IF() condition for each measure in a table object will work.  Another alternative is using set analysis if you want your table to not be affected by what the user selects in the quarter field.

Cheers,

Sean

Not applicable
Author

Thank you Sean

Danie Wium

+27 82 561 8350

Sent from my Samsung Galaxy smartphone.

Not applicable
Author

Hello Miguel,

can you share your solution for creating a cross table visualization?

I need the rows on my cross table to be sum of fields (each row a sum of a Boolean field (0/1) of my data set) and the columns are subsets of the data set over where the sum needs to happen. I have a flat data set with several fields, but as an example of the few I need for this summary cross tab:

bo_admitflag bo_enrolledflag date_admit   enroll_year

1                     1                       12.01.2015  2016

.....

the rows and columns on the cross tables would be

                                sum(bo_admitflag) for previous EOF  sum(enrolledflag) for previous EOY  Sum(bo_adm..) YTD .

sum(bo_admitflag) 

sum(bo_enrolledflag)

....

See attached image of the kind of cross table I need.

The Qlik Sense desktop table chart allows me to create the aggregate functions but there are only columns on it; The pivot chart does not allow me to create aggregation expression as row only measures. I thought it would be easy, but I am struggling; I am  new on Qlik.  Thanks, Alice

TrackingTabExamp.PNG