topic Re: QlikSense fixing column width in App Development

QlikSense fixing column width

Thu, 31 Mar 2016 14:07:50 GMT

Can the column width be fixed (saved) in QlikSense.

Column width in QlikSense are in some case not saved ?

How can we fix the column width in QlikSense .

thx

Re: QlikSense fixing column width

Fri, 01 Apr 2016 12:06:22 GMT

The only way I know you can do this is to Build your tables in a Pivot table. The basic table will always allow the user to change the column size its just the way Qlik has been made. this does have its benefits as it allows the user to expand and move the data to make it easier to read.

If you really need the Columns to be fixed then best to use a Pivot Table

Hope this helps

Re: QlikSense fixing column width

Mon, 04 Apr 2016 11:16:48 GMT

Hi,

But after selection of Pivot table its shows all the column which would not required.

how can we kept them hide..?

Re: QlikSense fixing column width

Mon, 04 Apr 2016 13:10:38 GMT

I do this by creating a Sub Status in the Load Script

So if I have a column with Multiple values like payment status with the below in the column

Paid

Waiting

settled

invoiced

And I only wanted to see 'Paid' the Load Script would be Like this:

Load * Inline [

'Payment Status', 'Paid Only'

'Paid' , 'Paid'

];

then in the Pivot when you add Paid Only as the Columns it will only show Paid and exclude the rest

if you can give me the column name and the fields I can write the load script for you

Hope this helps

Re: QlikSense fixing column width

Mon, 04 Apr 2016 17:20:51 GMT

OK but the orginal question was to fix the column width in QlikSense.

If ok, Is the column width saved per end-user ?

Re: QlikSense fixing column width

Anonymous — Mon, 04 Apr 2016 19:35:31 GMT

Qlik Sense auto sizes objects and pages based on the screen size so there is no way to adjust or fix the column widths.

Re: QlikSense fixing column width

reddy-s — Tue, 05 Apr 2016 13:04:49 GMT

Qliksense has a responsive design and this helps in giving a very intuitive look. This is the reason why the columns resize and adjust to the screen resolution. If you still would like to fix the column width, you will have to go with an extension object.

Re: QlikSense fixing column width

Tue, 05 Apr 2016 17:55:45 GMT

OK thx. What is a possible extension to fix wcolumn width ?

Re: QlikSense fixing column width

reddy-s — Wed, 06 Apr 2016 08:39:19 GMT

Hi Marc,

I am not sure if there is an extension already out there but its surely developable.

Re: QlikSense fixing column width

qvqfqlik — Thu, 19 Oct 2017 14:34:27 GMT

1. Try to adjust the column width as you need

2. Click on edit and select 'apply'

this will fix the column width

Re: QlikSense fixing column width

dimitar_angelov — Sun, 03 Dec 2017 10:14:59 GMT

This will fix the column width for you, but is another user opens the application it will behave "responsively" and it will fuck up everything you did. Filter pane for example is the most useless item in Qlik Sense so far because of the "intuitive" adjustment. Just publish an app to a wide group of users and you will see what I mean.

Fixing column width is not possible. Extension will make it possible but one the other objects on your sheet adjust to another user resolution the extension will have to use what is left of the space on the screen and it is very likely to get good results with some users and awful with others.

Re: QlikSense fixing column width

JoshD1 — Thu, 09 Nov 2023 23:03:23 GMT

Ureka!!!

There is a way to adjust column width in a table (straight table)

In NOT edit mode, select the table in question > Right Clik >Select Full screen view.

When in full-screen view you can adjust the column width as you would in Excel or the good old QlikView.

After adjusting the column widths to your satisfaction right-click and return to regular view.

Switch to Edit mode and adjust the overall table width to how you want it and the columns' width will remain adjusted.

Re: QlikSense fixing column width

AntonAlard — Tue, 04 Jun 2024 07:32:25 GMT

Thanks, this works fine even in 2024.