topic Blank space in QlikView

Blank space

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

Hi All ,

Please find the attachment of the QVW application .

I have a pivot table , if you look i have made the Date(Month) to appear horizontal , i am facing a Ui issue here ,

If you observe at the column Branch there is a slight space , and i cant fill it .

Can somone tell me how do i elimnate this blank space ?

Thanks .

Re: Blank space

rahulpawarb — Wed, 22 Mar 2017 05:56:38 GMT

Hello John,

Trust that you are doing good!

The space you are referencing is the column header for Date(Month) field. I strongly believe that you can not remove it from cross tab.

Hope this will be helpful.

Regards!

Rahul

Re: Blank space

vijetas42 — Wed, 22 Mar 2017 06:04:53 GMT

Hi,

you can not delete that blank space from pivot table for just to do adjustment you can put same color text box on that smaller space so that it will look like part of column branch.

Re: Blank space

smilingjohn — Wed, 22 Mar 2017 06:20:47 GMT

Hi Viheta ,

Thanks for the reply ,

I used a text object with same column , But the thng is that when there is no data , only two column will be shown , and this text object will appear like a patch , which needs to be invisible when there is no data . for total column

Re: Blank space

neha_shirsath — Wed, 22 Mar 2017 07:03:36 GMT

Hi John,

Please find the attached file, hope it is what exactly you want.

For this go to your dashboard setting>Design tab> enable Always show Design Menu Items.

Then right click on your chart properties and click on Custom format cell then arrange color and background color accordingly.

Let me know if you understand this.

Thanks,

Neha

Re: Blank space

stabben23 — Wed, 22 Mar 2017 07:30:06 GMT

Hi John,

you could use a macro as a workaround. You need to trigger the macro in some way, maybe by onopen.

Sub HideDim
set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties
' set the width of the 4th dimension to 0
chart.SetPixWidth 3,0 '3 will be your 4th dim, starts with 0
End sub

Re: Blank space

smilingjohn — Wed, 22 Mar 2017 07:50:38 GMT

Hi Neha ,

I followed ur steps but its not working in my real time app .

Re: Blank space

neha_shirsath — Wed, 22 Mar 2017 07:56:37 GMT

You have to do some trial and error.

What I have attached in that file,I think same way you have to do.

check properties of the same,It should work.

Thanks,

Neha