Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
fheidenstecker
Creator II
Creator II

Format Pivot Table in Qlik Sense

Hello Qlik Community,

is it possible to give a pivot table some extra formatting ?

The issues have are :

- It is not possible to change column width? A lot of space is wasted

- Chosse smaller font

- Turn of word wrapping, as item / customer numbers become unreadable.....

- No custom sorting via double Click

Also, is there any way to print a pivot table?

Is there no more option where to show totals , buttom or top?

Thanks for any advice,

Fabian

6 Replies
Gysbert_Wassenaar

No, the pivot table has limited options for formatting. Perhaps in a later release of Qlik Sense more options will be added.


talk is cheap, supply exceeds demand
miguelbraga
Partner - Specialist III
Partner - Specialist III

Hey there,

As far as I know, in Qlik Sense:

  1. There is no option to change column width unfornatly;
  2. The font size is automacally resized because QS is also devoloped for mobile devices
  3. You can't turn off wrapping
  4. You can't turn off this feature

You can print pivot table by right click in mouse

You'll see these options.

Regards,

MB

fheidenstecker
Creator II
Creator II
Author

miguelbraga‌ This will only print the visible part of the pivot table, which makes the printing option a rather useless feature....

fheidenstecker
Creator II
Creator II
Author

Allright gwassenaar‌, i hope this visualisation becomes useable in Sense 4.0 then

miguelbraga
Partner - Specialist III
Partner - Specialist III

I'm affraid you'll need to Export data from Qlik Sense to Excel and then you can print inside Excel. The option of printing some pivot table is only feature in QlikView. Maybe in future releases they will include that feature in Qlik Sense, who knows?

Regards,

MB

alextimofeyev
Partner - Creator II
Partner - Creator II

It is now possible to change the width of the dimension column. You have to do it in the View mode, and then go to the Edit mode and apply the changes to the viz.