topic Freeze Columns in Table Box in QlikView

Freeze Columns in Table Box

bjsellers57 — Tue, 29 Apr 2014 18:08:46 GMT

The Table Box has a similar look/feel of an Excel Spreadsheet, but does not allow a way to freeze columns that may be important to remain static for reasobly identify the data keys. It would be nice if there were a selection under the presentation tab that user could define fields that you want to remain static(Freeze).

Re: Freeze Columns in Table Box

Tue, 29 Apr 2014 23:31:19 GMT

You may define in your document alternate state, where user doesnt make selections and set table box to work in that state. It will always show full data set.

regards

Darek.

Re: Freeze Columns in Table Box

rwunderlich — Wed, 30 Apr 2014 00:39:27 GMT

Use a Straight Table Chart instead of a Table Box. Dimensions in a Straight Table don't scroll.

-Rob

Re: Freeze Columns in Table Box

bjsellers57 — Wed, 30 Apr 2014 10:50:05 GMT

Thanks Rob and I have used a straight chart, but as well it has limitations. My data source contains 40 fields and I am trying to contain the fields in a normal monitor space which requires scrolling the data. None of the data really requires expressions, but I used expressions to host the data thus allowing the dimensions field to lock in place. Limitations are: 1) you cannot do drop downs on on the expression fields 2) if you select a filtering through the expression section the app only selects specific of the dimension. The customer is looking for almost a look and feel of MS Excel where the main data source/key fields are locked, but also allowing drop-down and/or filtering selections to the other fields. All within a limitation of the normal monitor 1024x768.