I'm not a QlikView expert, but I seem to be beating my head against a trivial(?) issue, and whilst I have an answer I feel there must be a better one.
When developing in the client, table data frequently overflow the columns (giving the ##### display) . The quick answer is to right-click and select "Fit columns to data", and all is fine.
Now when the app is loaded into the Web access point, and loaded via browser, this option has gone. But it doesn't apparently matter, as the tables seem to autosize to the data.
Except for the headings. If I have a column headed 'Year', and have 4-digit years, then it's quite a tight well-fitted column. But if someone actually selects by year, what you often get is something like "Ye", then a green blob and the sort arrowhead. My users don't like this.
Now in the development client, going right-click and select "Fit columns to data" works. But you can't do this in the web view.
I know there is a zoom macro floating about using FitZoomToWindow, but (a) it doesn't solve the problem, and (b) in the development client it seems to work by changing the font size: something else that's not wanted.
There is the approach of explicitly setting each and every column width in each and every object via a macro, but that's rapidly going to get out of hand.
The only way I've found to kludge it is by making all the "Year" headings "Year......", with a 5-dot ellipsis. This provides space for the green blob and sort symbol, at the cost of making the column a bit wider. I'm trying to sell this to the users as a marker to show this is a selectable item, but I don't think they're going to buy it.
I feel that there should be a relatively simple way of resizing the column when the selection marker comes up, but can't find it. I'd be grateful for any and all suggestions!
Prune.
