topic Formatting Issue in QlikView

Formatting Issue

Thu, 29 Aug 2013 09:52:03 GMT

I am having a formatting issue in pivot.

In the attached JPEG file,

Number of Engaged telephonic Coached Members & Percentage of Engaged telephonic Coached Members are expressions and month is the dimension.

If you see in the Attached Jpeg,Expression labels are large whereas the data eg 1 for Jan is small but the foramtting is not correct.

I want the data to be fit with the column without toouchng the expression labels.

Re: Formatting Issue

CELAMBARASAN — Thu, 29 Aug 2013 09:55:06 GMT

Hi,

This is not possible here.

Because you have pivoted the dimensions to X axis and Expressions to Y axis.

Column width for the expression values always based on the expressions width.

Re: Formatting Issue

er_mohit — Thu, 29 Aug 2013 10:18:25 GMT

right click on chart and fit coloumn to data if it doent succeed your required issue then put a cursor on expression line where is jan on top row then you 'll see the cross type sign when you put your cursor on the line then double click on it hope it helps

or you can try the macro code for this create a button and add action

sub x

set chart = ActiveDocument.GetSheetObject("CH02") // here put object id of pivot

chart.SetPixWidth 0,100

chart.SetPixWidth 1,100

chart.SetPixWidth 2, 0

end sub

after that click on button