Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table Qlik Sense

I want to a report by pivot table in Qlik Sense, like (in QlikView):

Kết quả hình ảnh cho pivot table qlik sense

But, in Qlik Sense, report like:

Hình ảnh có liên quan

I want each column only a field (like qlikview) and add sub total row in report.

7 Replies
Anonymous
Not applicable
Author

report like:

Kết quả hình ảnh cho pivot table qlik sense

Anonymous
Not applicable
Author

You may use a pivot table extension like js pivot table which is nearer to your requirement Qlik Branch

OmarBenSalem

Like this?

Capture.PNG

Activate the total in the dimensions

and under prestentation, uncheck this:

Capture.PNG

Anonymous
Not applicable
Author

But, if I use extension, I can not colapse table. Do you have any other way?

Anonymous
Not applicable
Author

Sub total column. How do I get it?

OmarBenSalem

Activate the total on each dimension you want :

Capture.PNG

Anonymous
Not applicable
Author

Thanks omarbensalem‌, I want to add header name for my table, like picture:

Untitled12.png

And my table is large. I need Horizontal Scrollbar, but I do not see it in Qlik Sense.