topic Re: Scroll bar issue with straight table in QlikView

Scroll bar issue with straight table

varunreddy — Tue, 24 Oct 2017 17:07:48 GMT

Hi All,

I am trying to create Dynamic report, which includes 75 dimensions and 3 metrics. I am using straight table for this. When I select all the dimensions, I am getting the scroll bar for the sheet and not the report. Could you please guide?

Cheers,

Varun

Re: Scroll bar issue with straight table

m_woolf — Tue, 24 Oct 2017 17:11:33 GMT

When using a straight table, the horizontal scrollbar is for expressions (metrics), not dimensions..

Re: Scroll bar issue with straight table

varunreddy — Tue, 24 Oct 2017 17:13:04 GMT

Is there any alternative for this?

Re: Scroll bar issue with straight table

rubenmarin — Tue, 24 Oct 2017 17:25:10 GMT

Hi Varun, I think the only way is giving enough space, set more pixels for width in the title tab.

In design tab, the option to 'fix to data' can help for better looking of the table

Re: Scroll bar issue with straight table

m_woolf — Tue, 24 Oct 2017 17:25:24 GMT

You can set you first few dimensions as dimensions and add the rest as expressions.

Re: Scroll bar issue with straight table

varunreddy — Tue, 24 Oct 2017 17:26:48 GMT

The dimensions will be selected by the users, so we cannot fix the order

Re: Scroll bar issue with straight table

Anonymous — Tue, 24 Oct 2017 17:36:18 GMT

The only workaround I have 'heard' of possibly working is to put the entire table into a container.

Re: Scroll bar issue with straight table

varunreddy — Tue, 24 Oct 2017 17:40:10 GMT

I tried but the container is not giving scroll bar

Re: Scroll bar issue with straight table

Anonymous — Tue, 24 Oct 2017 17:48:38 GMT

that was my only advice. is your container narrower than the width of your table?