topic Re: How to shrink a pivot table column in App Development

How to shrink a pivot table column

herard_bertrand — Wed, 30 Aug 2023 14:00:46 GMT

Hello,

I made a pivot table in Qlik Sense, I added some dimension on the left then Qlik sense displays a very large column for values (large means all remaining space :)).

That's an issue because I've 4 calculations measures in my pivot table and I can only see it one by one.

Is there a way to shrink the pivot table measures columns width ?

Best regards

Re: How to shrink a pivot table column

Zapparoli — Wed, 30 Aug 2023 18:28:27 GMT

Hi @herard_bertrand

Not sure if I understood it correctly, but can't you drag the borders to the left ?

Would you kindly print and example ?

Zapparoli.

Re: How to shrink a pivot table column

herard_bertrand — Thu, 31 Aug 2023 07:38:17 GMT

Hello,

thanks for your answer,

My problem is on measures column size.

in your example, what would you do if the TV Sales column was so large that you couldn't see it and the column LY Sales (except using slider) at the same time ?

Re: How to shrink a pivot table column

Zapparoli — Thu, 31 Aug 2023 13:09:19 GMT

Hi Herard,

Thanks for the clarification, I did some testing, like your scenario and I could go back to "Normal" by checking/unchecking the "Ident Rows" in the presentation tab:

Can you try the same and let me know ?

Zapparoli

Re: How to shrink a pivot table column

Or — Thu, 31 Aug 2023 13:22:32 GMT

As far as I know, there is no way to control the individual measure size in Qlik's native pivot table. Qlik Sense decides on its own how large to make them based on the contents and the available space. The only way to reduce the size it assigns is to make the contents shorter.

Some extensions do offer an option to set a custom size for measure columns - for example, Vizlib Pivot Table - if that's something you want to look into.

Re: How to shrink a pivot table column

MatheusC — Thu, 31 Aug 2023 13:34:11 GMT

Hi, Who knows how to use an improvisation with cacatenar,
ex:

concatenate your measurement with the space you want it to occupy

sum(average) & '     '

Re: How to shrink a pivot table column

herard_bertrand — Thu, 31 Aug 2023 13:40:24 GMT

Hi,

I tried to play with theses button but it doesn't change anything :

in this example the column Pattern Occupy half of my screen :

I've 4 measures (including Pattern) and I want to see the 4 measure for each brand 😅

Re: How to shrink a pivot table column

herard_bertrand — Thu, 31 Aug 2023 13:41:58 GMT

By the way thanks for the effort ^^

Re: How to shrink a pivot table column

herard_bertrand — Thu, 31 Aug 2023 13:44:11 GMT

"As far as I know, there is no way to control the individual measure size in Qlik's native pivot table. Qlik Sense decides on its own how large to make them based on the contents and the available space."

That's what I fear 😅

"Some extensions do offer an option to set a custom size for measure columns - for example, Vizlib Pivot Table"

Why not, do you know where I can find Pivot table extension ? (such as Vizlib Pivot Table). I'm new to Qlik Cloud and I'm not used to find / add extensions

Re: How to shrink a pivot table column

herard_bertrand — Thu, 31 Aug 2023 13:58:07 GMT

Hi thanks for the tips,

I think the issue is clearly Qlik uses the max widht of one value for each measures.

I think your solution should work when the column is too small, I've the opposite issue : my columns are too long.
I've 2 measures using concat(Distinct MyIndicator, ', ').

By the way, I tried something like :

concat(Distinct MyIndicator, ', '&chr(10)&chr(13)) or

concat(Distinct MyIndicator, ',

').

but it didn't worked (it seems we can't wrap cells value into multiple lines).

thanks anyway ^^

Re: How to shrink a pivot table column

Or — Thu, 31 Aug 2023 14:17:30 GMT

You can search for extensions on Google and visit the developer's website. In many cases, the better extensions are not free to use on a large scale, though, so keep that in mind.

Depending on what exactly you've got in your measures, you could try limiting the length to a set level, which would allow the engine to reduce the width. For example, Left(YourField,50) to just get the 50 leftmost characters in whatever you're presenting. For most use cases where you're presenting text in a pivot table measure, I would expect a certain number of characters to be good enough, as pivot tables aren't really meant to display large chunks of text...

Re: How to shrink a pivot table column

herard_bertrand — Wed, 06 Sep 2023 07:25:13 GMT

Thanks for your idea.

Anyway, as there is no native solution, and in general, the pivot table seems not finished yet (and it exists a lot of complaints about it on the forum for a looooong time ago). I'm going to use another software to do my reporting.

Thanks 🙂

Re: How to shrink a pivot table column

McDonald-1022 — Wed, 17 Apr 2024 14:48:20 GMT

There are currently two Pivot Tables (as of 4/17/24). One in "Charts" and one in "Qlik Visualization Bundle". The Pivot in Charts does not allow you to resize, the one in Visualization Bundle does. Use that one