topic Reducing Blank Space in Pivot Table in QlikView

Reducing Blank Space in Pivot Table

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi I am using Pivot table to show my report. It has some unnecessary space. I am not able to remove that.

Could you please help me to remove?

Thanks,

Sarif

Re: Reducing Blank Space in Pivot Table

Anonymous — Fri, 07 Apr 2017 11:18:43 GMT

Hi,

May be uncheck your "Multi-line parameter" ? In Presentation Tab

Re: Reducing Blank Space in Pivot Table

sunny_talwar — Fri, 07 Apr 2017 11:19:01 GMT

Check the multi-line settings on the Presentation tab to see

Make sure the Header Height is not set to be too high

Re: Reducing Blank Space in Pivot Table

mhmmd_srf — Fri, 07 Apr 2017 11:49:20 GMT

Not helping sir..

Re: Reducing Blank Space in Pivot Table

sunny_talwar — Fri, 07 Apr 2017 11:51:09 GMT

Can you share a screenshot of these settings?

Re: Reducing Blank Space in Pivot Table

dsharmaqv — Fri, 07 Apr 2017 11:51:54 GMT

can you post your sample app

Re: Reducing Blank Space in Pivot Table

mhmmd_srf — Fri, 07 Apr 2017 11:51:58 GMT

Re: Reducing Blank Space in Pivot Table

dsharmaqv — Fri, 07 Apr 2017 11:55:08 GMT

you have setted up lable as vertical..... Please check if any of the lable with long names

Re: Reducing Blank Space in Pivot Table

mhmmd_srf — Fri, 07 Apr 2017 11:56:57 GMT

Pasting the App

Re: Reducing Blank Space in Pivot Table

mhmmd_srf — Fri, 07 Apr 2017 12:02:02 GMT

No Long Names are there..

Re: Reducing Blank Space in Pivot Table

Anonymous — Fri, 07 Apr 2017 12:16:22 GMT

try to close and reopen your APP. I don't have the same behavior when I open your App and I have same properties.

Re: Reducing Blank Space in Pivot Table

mhmmd_srf — Fri, 07 Apr 2017 12:19:02 GMT

Please check First tab.. not second tab.. second tab I have created freshly...there also one issue... the data is not in single line...

Re: Reducing Blank Space in Pivot Table

Anonymous — Fri, 07 Apr 2017 12:24:38 GMT

Give a name to your expression.

Re: Reducing Blank Space in Pivot Table

Anonymous — Fri, 07 Apr 2017 12:25:52 GMT

Please see attached app

Re: Reducing Blank Space in Pivot Table

Anonymous — Fri, 07 Apr 2017 12:30:57 GMT

To make sure that the data will be in single line you can put as your expression name DD/MM/YYYY

Re: Reducing Blank Space in Pivot Table

rahulpawarb — Fri, 07 Apr 2017 12:31:52 GMT

Hello Mohammad,

Trust that you are doing well!

As per my observation, If you assign label to expression present in chart 'Back Order Report SKUs - Historical Trends' then you can see the desired output (refer attached application; I have added ORDER QTY label for the available expression).

I believe that this is happening because of length of expression is taken into consideration while rendering the chart.

Hope this makes sense.

Regards!

Rahul

Re: Reducing Blank Space in Pivot Table

Anonymous — Fri, 07 Apr 2017 13:16:50 GMT

Did you have your expected result Mohammad?

If yes, please mark this discussion as resolved to put a correct answer

It will help another people who has the same issue