topic Re: little white space at the end of listbox in accesspoint in QlikView

little white space at the end of listbox in accesspoint

kris_vliegen — Fri, 08 Aug 2014 07:29:05 GMT

Hi all,

This is how my listboxes looks in the desktopversion.

And this is how they look in the accesspoint.

At the end of the box there is a little white space. How can I remove this or fill the listbox with values?

Regards,

Kris

Re: little white space at the end of listbox in accesspoint

vardhancse — Fri, 08 Aug 2014 07:30:35 GMT

Try by removing Size to Data option for the list box

Re: little white space at the end of listbox in accesspoint

kris_vliegen — Fri, 08 Aug 2014 07:34:28 GMT

Thanx for your fast answer.

But where can I find that option?

Re: little white space at the end of listbox in accesspoint

vardhancse — Fri, 08 Aug 2014 07:38:26 GMT

Right Click->Properties->Layout->Size To Data(Check Box)

Re: little white space at the end of listbox in accesspoint

kris_vliegen — Fri, 08 Aug 2014 07:45:22 GMT

It doesn't work for my listbox...

The only different I see is that I get an extra white space under the month

Re: little white space at the end of listbox in accesspoint

senarath — Fri, 08 Aug 2014 08:01:59 GMT

Hi,

Normally you get something like that when there are NULL values. So you may need to handle that.

thanx

Re: little white space at the end of listbox in accesspoint

kris_vliegen — Fri, 08 Aug 2014 08:37:06 GMT

I don't think this is the problem.

I've changed the script so I only read the lines where len(_CalDay) > 0

This is the script:

Noconcatenate

MasterCalendar:

load

Datum,

DatumNum,

_CalDay,

_CalMonthNum,

_CalMonthNED,

dual(_CalMonthENG,_CalMonthNum) as _CalMonthENG,

dual(_CalMonthFRA,_CalMonthNum) as _CalMonthFRA,

_CalYear,

CalHour,

MonthYear,

CalWeekDay,

CalMonthYear,

CalDayMonth,

_CalQuarter,

CalWeekYear

resident MasterCalendarTemp1 where len(_CalDay) > 0 and len(_CalMonthNum) > 0;

Re: little white space at the end of listbox in accesspoint

senarath — Fri, 08 Aug 2014 08:44:12 GMT

Hi,

In that case, this should clearly be a presentation matter.

Look at below areas;

01. Size to Data

02. Make columns equally fit by right clicking

03. Manually drag border of last month up to the outer border

04. Set background 100% transparent (and remove border lines)

thanx

Re: little white space at the end of listbox in accesspoint

kris_vliegen — Fri, 08 Aug 2014 10:10:01 GMT

Hi,

The size to data doen't change anything.

I don't know what you mean about 2 and 3.

And I've set the background 100 % transparant and removed the borders.

But than I have this result

Why is there a gray line under the months and not under the days or months?

Regards,

Kris

Re: little white space at the end of listbox in accesspoint

thomasreynaert — Mon, 05 Mar 2018 15:06:42 GMT

Stumbled upon this topic and indeed seems to have the same issue. Lines 1 & 3 are local view, 2 & 4 are webview. The first ones are with border, the last ones without.

Anyway this annoying white space seems to pop-up. Wonder if there is a solution to this.