topic Re: Pivot Table in QlikView

Pivot Table

upaliwije — Fri, 06 Jan 2017 08:48:06 GMT

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

Re: Pivot Table

Anil_Babu_Samineni — Fri, 06 Jan 2017 08:54:50 GMT

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

Re: Pivot Table

upaliwije — Fri, 06 Jan 2017 09:08:03 GMT

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

Re: Pivot Table

Anil_Babu_Samineni — Fri, 06 Jan 2017 09:11:27 GMT

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

Re: Pivot Table

upaliwije — Fri, 06 Jan 2017 09:18:49 GMT

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

Re: Pivot Table

Anil_Babu_Samineni — Fri, 06 Jan 2017 09:23:12 GMT

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

Re: Pivot Table

el_aprendiz111 — Fri, 06 Jan 2017 19:54:07 GMT

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

Re: Pivot Table

MarcoWedel — Fri, 06 Jan 2017 22:02:44 GMT

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

Re: Pivot Table

upaliwije — Sat, 07 Jan 2017 05:09:59 GMT

i HAVE ATTACHED MY QV dOC . PSL ADVISE

Re: Pivot Table

HirisH_V7 — Sat, 07 Jan 2017 06:21:23 GMT

Hi,

Please reload your QVW, there no dimensions are active.

Else

Make a QVW with sample data.

-Hirish

Re: Pivot Table

upaliwije — Sat, 07 Jan 2017 15:47:34 GMT

Hi Thanks

Yu can use BCOD as a Dimension

Re: Pivot Table

MarcoWedel — Sat, 07 Jan 2017 21:38:11 GMT

There is no BCOD field in your sample application ...

hope this helps

regards

Marco

Re: Pivot Table

upaliwije — Sun, 08 Jan 2017 02:54:37 GMT

It is there

Re: Pivot Table

petter — Sun, 08 Jan 2017 10:07:32 GMT

I would be practical about it and use abbreviations with some legend explaining the abbreviations next to it:

In my opinion this is much more readable too ...

Re: Pivot Table

petter — Sun, 08 Jan 2017 12:27:44 GMT

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.