How to shrink a pivot table column

[herard_bertrand]

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

[Zapparoli]

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.

[herard_bertrand]

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 ?

[Zapparoli]

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

[Or]

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.

[MatheusC]

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

concatenate your measurement with the space you want it to occupy

sum(average) & '     '

[herard_bertrand]

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 😅

[herard_bertrand]

By the way thanks for the effort ^^

[herard_bertrand]

"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

[herard_bertrand]

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 ^^