topic Fit columns to data - Auto fit function? in QlikView

Fit columns to data - Auto fit function?

Wed, 02 Sep 2009 18:16:23 GMT

Hi,

I was wondering is there a autofit function that fits columns to data for reports when the user opens the document.

I use ActiveDocument.ActiveSheet.FitZoomToWindow for the actual report but as users have different resolution so when some users open a document the reports show ##### in the column (particular problem for totals), the user then has to manually expand the column which can be a bit of annoying.

I know that I can expand all columns in enterprise and save the document but when a figure increases fro 5 digits to 7 digits the problem re occurs.

Basically what I am asking: Is there a piece of script that I can run that will auto "fit columns to data" or has anybody got a different solution?

Thanks

Fit columns to data - Auto fit function?

johnan — Wed, 02 Sep 2009 20:56:40 GMT

Hi, i have askt this before. I't would be nice to have a function to this.
I have tested tihs on QV9(odernary way) and the rightclic on to choose "Fit columns to data" doesnt work att all.

Fit columns to data - Auto fit function?

Tue, 10 Nov 2009 01:22:21 GMT

I've recently discovered a need for this as well. Does anyone have any ideas?

Fit columns to data - Auto fit function?

Tue, 10 Nov 2009 16:13:40 GMT

I use the following macro for OnActivateSheet

sub zoom
ActiveDocument.ActiveSheet.FitZoomToWindow
end sub

It works almost all of the time but I find that when you have quite large documents it doesn't automatically trigger when the document initially opens. To trigger the macro I have to select a different worksheet and then go back to the first worksheet.

If anybody has any suggestions it would be greatly appreciated.