Solved: Pivot Table - Qlik Community

upaliwije · ‎2017-01-06

I have following pivot table in My qv document

YEAR	2010	2011	2012	2013	2014
STANDARD_DAYS_PM	35	37	46	31	31
ACTUAL DAYS PER MONTH	326	301	384	273	286
STANDARD_DAYS_PM	33	36	38	37	38
ACTUAL DAYS PER MONTH	111	129	138	138	146
STANDARD_DAYS_PM	24	38	39	40	41
ACTUAL DAYS PER MONTH	15	25	26	26	27
STANDARD_DAYS_PM	17	32	33	34	35
ACTUAL DAYS PER MONTH	15	31	32	33	35
STANDARD_DAYS_PM	27	31	32	33	34

I want to adjsut width of YEAR columns to be exactly like above and fisrt coloum with to be wider. But if I adjsut the width first column width of all other columns too expand. Is there any possibility of expanding the with of 1st coloumn only. The fist colum is an expression add year columums is a dimension

petter · ‎2017-01-08

In addition to the "practical" straight-forward approach I mentioned over there is a way of achieving exactly what you want.

The downside is that it is much more complicated and you will have to have a calculated dimension and a single expression with a Pick() function. In addition you will have to use a ValueList()-function to generate values for the calculated dimension.

1) Add a variable in the "Variable Overview" like this:

2) Add a Calculated Dimension amongst your dimensions like this:

3) Then finally have this single expression:

This will pick the right expression according to which dimension value that appears on each row.

Now you can size the calculated dimension column width independently from you expression.

I have attached your QVW with the updates to show have the final result will be and works in with your test data.

View solution in original post

Anil_Babu_Samineni · ‎2017-01-06

2 Options

1) Drag like where ever you want

2) You must get one symbol when you mouse over in B/W of two fields or measures like + Symbol, Then you may hit double stick for that

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

upaliwije · ‎2017-01-06

It is not clear to me can pls elaborate a little bit

Anil_Babu_Samineni · ‎2017-01-06

Can you confirm the same whether you are expecting Auto Width for each Field / What?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

upaliwije · ‎2017-01-06

I want 1st Coloum where legnth of the text large to have wider length and Value columns to be shorter.

Anil_Babu_Samineni · ‎2017-01-06

Where you are doing this. If straight or Pivot object then just place your mouse in between of Fields or expressions. So then, The mouse showing like + Symbol. Then double click the beside of the line and then it will stretched as per you are looking. I am not the good ex-plainer

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

el_aprendiz111 · ‎2017-01-06

Hi Upali:

try this macro

sub AutoFit

set chart = ActiveDocument.GetSheetObject("CH08")
chart.SetPixWidth 0,100
chart.SetPixWidth 1,100
chart.SetPixWidth 2,100

end sub

MarcoWedel · ‎2017-01-06

Hi,

I guess the behaviour you described should only occur for columns belonging to one horizontal dimension.

As the "YEAR" column (lable) itself should not be part of the value columns, your issue seems odd.

I'm not sure about your data model and pivot table structure.

Can you please post an example to demonstrate this behaviour?

thanks

regards

Marco

upaliwije · ‎2017-01-07

i HAVE ATTACHED MY QV dOC . PSL ADVISE

HirisH_V7 · ‎2017-01-07

Hi,

Please reload your QVW, there no dimensions are active.

Else

Make a QVW with sample data.

-Hirish

HirisH

Pivot Table

Related Topics