topic Re: Chart Properties Number Dialog Tab Clipped in QlikView

Chart Properties Number Dialog Tab Clipped

Wed, 27 Jun 2012 13:42:48 GMT

Qlikview:

I cannot see the entire dialog for formatting numbers in charts and tables as shown in the picture below. This is quite problematic as I need to format a chart to show GBP instead of USD.

Please tell me what I should do to correct this problem. Is there an update to download?

Re: Chart Properties Number Dialog Tab Clipped

Miguel_Angel_Baeyens — Wed, 27 Jun 2012 14:12:13 GMT

Hi,

If you mean you want to see the pattern, just click on any of the four expressions you have on the left, then check Integer or Number or Fixed to and set the pattern that you need.

Hope that helps.

Miguel

Re: Chart Properties Number Dialog Tab Clipped

Wed, 27 Jun 2012 14:14:56 GMT

Miguel,

Thank you for answering. I did paste a format into Format Pattern textbox as a workaround, but shouldn't there be some type of guide for creating the format expression. Plus, the UI is still clipped. Is there a way to submit this as a bug?

Cheers,

Ben

Re: Chart Properties Number Dialog Tab Clipped

Miguel_Angel_Baeyens — Wed, 27 Jun 2012 14:38:54 GMT

Hi Ben,

What version of QlikView are you running and what type of chart are you creating?

If you are working with QlikView Server or a licensed Site copy of QlikView, contact your nearest Support so they can assist you on whether this is or not a bug and the steps to fix it, if the former.

Hope that helps.

Miguel

Re: Chart Properties Number Dialog Tab Clipped

jonathandienst — Wed, 27 Jun 2012 14:59:53 GMT

Ben / Miguel

I have seen this dialog doing this on several high res screens (full HD monitors and 1680x1050 laptop screens). I saw this with V9 and V10 (and I think with V11 as well). Pretty certain this is a bug, but I never reported it.

Regards

Jonathan

Edit: Confirmed QV11 as well

Re: Chart Properties Number Dialog Tab Clipped

Wed, 27 Jun 2012 17:33:35 GMT

I am running a laptop with high screen resolution; will reduce res and see if the issue is fixed.

Re: Chart Properties Number Dialog Tab Clipped

adamwilson — Mon, 08 Sep 2014 10:02:17 GMT

Has this issue been fixed? I am getting the same issue with QlikView 11.20 SR6 and SR7.

Re: Chart Properties Number Dialog Tab Clipped

jrg — Wed, 01 Jun 2016 12:35:01 GMT

Bump on this please.

I have had this on v11, v11.2 and now v12 and my machine STILL clips that number tab off, exactly as per the screenshot. I really need a resolution of how to prevent this.

Re: Chart Properties Number Dialog Tab Clipped

marcus_sommer — Wed, 01 Jun 2016 13:06:16 GMT

I think the reason will be within your user-profile. Either on the qlikview-side (maybe some settings within the easter egg have side-effects - you could make a backup from the settings.ini and delete them and if not you could make it reverse) or on the windows-side (qlikview used various windows functions/settings, maybe such as the 1904-date mode in excel (I have no idea if this is isolated in excel or a system-setting) and maybe there is anywhere an error or conflict).

- Marcus

Re: Chart Properties Number Dialog Tab Clipped

jrg — Wed, 01 Jun 2016 13:25:50 GMT

Great thoughts, Marcus, thank you.

I'm willing to try anything and I know without the product source code to hand, it's the only way I can resolve it.

I tried with a different user profile. Indeed, it was back at Personal Edition, too.

To no avail.

What gets me is that it is JUST this dialog box. And if you look carefully at the original screenshot (which is 100% the same as I get), it is not the entire tab. It is just the "Number Format Settings" group area on the right three-quarters of the dialog area. In fact, it is not even that entire group, since the four symbol box controls are unaffected. It is purely the font and UI control scaling for the radio controls on the left (and the % checkbox) along with the format and separators group on the right. They do end up overlapping the other controls which are still exactly where they should be at the scale they should be.

It always looked more like a graphics card driver clash with something to me, but I've seen it on multiple different systems of different brands over the last three years and nobody has ever been able to fix it.

Once you know you can tab between the controls and second guess it, it doesn't prevent you doing things, but I'll be damned if I'm about to create a training video of how to create charts within the product and show that embarassing glitch.

Re: Chart Properties Number Dialog Tab Clipped

marcus_sommer — Wed, 01 Jun 2016 15:56:16 GMT

Maybe it's related to this topic: Fix the QlikView chart properties dialog The Qlik Fix!

- Marcus

Re: Chart Properties Number Dialog Tab Clipped

jrg — Wed, 01 Jun 2016 16:14:13 GMT

That's mighty interesting, Marcus, thank you.

I have to keep my QV installation as default as I can for training purposes, so I certainly haven't been hacking away at my .dll files to cause it, but it is certainly nice to know about that .dll and what can be done.

It may well be some clash with what is going on with those settings in there, too.

If only I could get away with doing that - but I need QV to look as standard as possible for the videos I record.

Worth testing out after backing up the .dll though, for sure.

Quite why QV would circumstantially apply 125% scaling to those UI elements of that specific tab in that specific dialog (for just a handful of machines) I would love to know.

Re: Chart Properties Number Dialog Tab Clipped

marcus_sommer — Wed, 01 Jun 2016 16:33:44 GMT

Yes, in this case you shouldn't easily hack the system or make any kinds of customizing. I could imagine that there is a certain combination from hardware (graphic cards) and system settings. Maybe onboard-graphic and graphic card and their drivers and/or screen-resolutions respectively the windows-magnification (the size from icon, menu and so on), cleartype-settings and similar are conflicting with eachother.

Maybe you could start your machine within the secured mode from windows without loading nearly everything so that the system used some very basic graphic driver with such resolutions like 480*600 or 600*800 - just to check if some reasons could found or excluded.

- Marcus

Re: Chart Properties Number Dialog Tab Clipped

jrg — Wed, 01 Jun 2016 17:06:53 GMT

Well, I fixed it myself.

With assistance from your previous linked info.

I cannot in any way condone what I did, but resource 155:1033 in the .dll is incorrect as far as my system is concerned.

The font used for the number group component is "MS Shell Serif".

Checking other similar resources, I noted they used "MS Shell Dlg", FW_Normal, False, 1.

So I just pasted over what looked about right and voila, it has fixed the issue.

Only took 3yrs!

Thanks to your link there, Marcus.

The hacker in me couldn't resist having a go myself at that one.