topic Re: Format Pivot Table in Qlik Sense in App Development

Format Pivot Table in Qlik Sense

fheidenstecker — Mon, 05 Sep 2016 15:44:00 GMT

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

Re: Format Pivot Table in Qlik Sense

Gysbert_Wassenaar — Mon, 05 Sep 2016 16:29:32 GMT

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

Re: Format Pivot Table in Qlik Sense

miguelbraga — Mon, 05 Sep 2016 16:35:14 GMT

Hey there,

As far as I know, in Qlik Sense:

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

You can print pivot table by right click in mouse

You'll see these options.

Regards,

Re: Format Pivot Table in Qlik Sense

fheidenstecker — Tue, 06 Sep 2016 07:10:53 GMT

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

Re: Format Pivot Table in Qlik Sense

fheidenstecker — Tue, 06 Sep 2016 07:12:22 GMT

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

Re: Format Pivot Table in Qlik Sense

miguelbraga — Tue, 06 Sep 2016 08:11:17 GMT

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,

Re: Format Pivot Table in Qlik Sense

alextimofeyev — Sat, 22 Apr 2017 18:28:22 GMT

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.