Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

fheidenstecker
Contributor 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

Tags (4)
6 Replies

Re: Format Pivot Table in Qlik Sense

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
Valued Contributor III

Re: Format Pivot Table in Qlik Sense

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
Contributor II

Re: Format Pivot Table in Qlik Sense

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

fheidenstecker
Contributor II

Re: Format Pivot Table in Qlik Sense

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

miguelbraga
Valued Contributor III

Re: Format Pivot Table in Qlik Sense

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
Contributor II

Re: Format Pivot Table in Qlik Sense

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.