topic Re: Listbox resize issue in QlikView

Listbox resize issue

Fri, 18 Sep 2015 12:29:23 GMT

Hi folks, I've tried toggling the Document Properties Size to Data option off / on but am still experiencing an annoyance in that listbox fields (with expressions) are randomly auto-resizing themselves to be tiny width so that the number is not visible at all. I have to manually re-size them. Saving the entire document doesn't keep the size as it is seen. Any ideas how this can be addressed so that the listbox width (single-row) remains static?

Re: Listbox resize issue

Colin-Albert — Fri, 18 Sep 2015 13:36:24 GMT

Can you post which version of QlikView you are using and the build number?

This may help identify if this is a new issue or a known issue.

Re: Listbox resize issue

Fri, 18 Sep 2015 13:39:02 GMT

Hi Colin, we're on Version 11.20.12354.0 SR6 64-bit Edition, many thanks, Alex

Re: Listbox resize issue

Colin-Albert — Fri, 18 Sep 2015 13:50:34 GMT

Hi Alex,

The current release is 11.2 SR12 build 12904. Have you tested the issue to see if it occurs in the current version?

Re: Listbox resize issue

Fri, 18 Sep 2015 13:55:34 GMT

That's the only release available to me at the current time. I've enquired as to whether we're moving forward or not, although I suspect an update won't materialise in the v.near future. Any ideas as to how I can force the listbox to do what I want in this respect?

Re: Listbox resize issue

sudeepkm — Fri, 18 Sep 2015 14:19:11 GMT

have you tried "Presentation > Suppress Horizontal Scroll bar"

Re: Listbox resize issue

Fri, 18 Sep 2015 14:22:09 GMT

I've also just noticed the same issue when copying & pasting (CTRL-Insert/SHIFT-Insert) a listbox. Most of the time it duplicates and overlays the object on top of the one that was copied. Sometimes however, it just auto-resizes as per my post above.

Re: Listbox resize issue

Fri, 18 Sep 2015 14:23:27 GMT

Will give it a go.

Re: Listbox resize issue

jonathandienst — Fri, 18 Sep 2015 14:24:32 GMT

I am not aware of such an issue in earlier releases, so it may be some peculiarity of he qvw file causing the issue. Can you upload the problem file? If security is a concern, you could scramble the sensitive fields, or upload a sample, as long as that still has the problem.

For info on reducing and scrambling:

Preparing examples for Upload - Reduction and Data Scrambling

Re: Listbox resize issue

Fri, 18 Sep 2015 14:31:41 GMT

Thanks Sudeep, but that doesn't have any impact.

Re: Listbox resize issue

sudeepkm — Fri, 18 Sep 2015 14:33:18 GMT

oh. if possible could you pls post a sample one here. Just wanted to check from my system.

Re: Listbox resize issue

Fri, 18 Sep 2015 14:39:03 GMT

Hi Jonathan, the only thing with Scramble is that it doesn't scramble the fields names (for good reason) and I've got a lot of fields in the QVW. The scramble output looks fine though . I'm not comfortable posting the scramble at the current time. However, I'll look to see if I can create a QVW that is not sensitive in any way and will post accordingly.

Re: Listbox resize issue

Fri, 18 Sep 2015 14:41:15 GMT

Interestingly, I just saved the scramble and for the first time ever (in over 3mths), QV has crashed with the message "A problem caused the program to stop working correctly. Please close the program.".

Re: Listbox resize issue

Fri, 18 Sep 2015 15:00:43 GMT

Here's a version with practically everything removed. One of the things I just tried was to set the Alternate State of the listbox to <default state> because one of the offending items was set to <inherited>. I saved the QVW and re-opened in my version and the listbox was the same state as it was when I had last saved it.

Anyway, hope the attached is still useful, your help much appreciated.

Re: Listbox resize issue

Fri, 18 Sep 2015 15:35:57 GMT

It seems this issue is Theme related. I've now applied a default theme to listbox creation and the problem has gone away.