Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
infosense_devel
Creator II
Creator II

Pivot table column width.

Hello All,

i have pivot table same as below.

table1.png

where if i increase size of Expression Labels then the Column width is also getting increased automatically.

i need expression label same size but want to decrease width of Columns.

thanks in advance.

1 Solution

Accepted Solutions
infosense_devel
Creator II
Creator II
Author

Thanks You for Replay, But I have transformed pivot table to straight table to get it Done.

View solution in original post

8 Replies
Anil_Babu_Samineni

1) For fit the column may be Right Click and use Fit Columns To Data.

2) What expression you are expecting?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
el_aprendiz111
Specialist
Specialist

Hi,

Macro:

sub AutoFit

set chart = ActiveDocument.GetSheetObject("CH13")

chart.SetPixWidth 0,100

chart.SetPixWidth 1,100

chart.SetPixWidth 2,100

chart.SetPixWidth 3,100

chart.SetPixWidth 4,100

end sub

infosense_devel
Creator II
Creator II
Author

Thanks You for Replay, But I have transformed pivot table to straight table to get it Done.

Anil_Babu_Samineni

Then close this thread by flag of correct answer of your Response

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ElizaF
Creator II
Creator II

I know it is closed this thread, but I faced with same problem .

The solution is to create another dimension (dummy dimension, moved on vertically) and after you can change the width of the Columns.

It is a QlikView tricks . Try it.

jessica_webb
Creator III
Creator III

Hi Eliza,

I've tried your trick but can't get it to work.

I have two dimensions - one vertical with the expression label to the right, and one horizontal with the expression value beneath.

I've added a dummy dimension, but still, my expression label cells and expression value cells change size with each other.

Any ideas what I'm doing wrong?

Thanks,
Jess

qlikviewforum
Creator II
Creator II

Hi Elisa and all,

Anyone got any solution while using pivot table? Please share the solution if you have find any.

Yakushi
Partner - Contributor
Partner - Contributor

Hello,

didn't find a solution using the pivot table, but you can replace it with a straight table and check the Horizontale box in the Presentation tab.

Regards.