topic Re: Keeping straight table size fixed in QlikView

Keeping straight table size fixed

rsdhavle — Mon, 13 Jan 2014 10:53:06 GMT

After making certain selections straight table size changes and keeps on increasing or dcreasing even if move/size option is unchecked. Is there any way to keep the table size fixed?

Re: Keeping straight table size fixed

maxgro — Mon, 13 Jan 2014 11:13:29 GMT

Hi Rohan

sometimes I use a container (grid 1 x 1) and I put the table in the container: the table changes the size but the container doesn't .

Perhaps it can help you.

Regards

Re: Keeping straight table size fixed

rsdhavle — Mon, 13 Jan 2014 11:18:34 GMT

I thought of this but can we add text boxes in the container and remove or hide tabs automatically created by container

Re: Keeping straight table size fixed

Colin-Albert — Mon, 13 Jan 2014 11:21:12 GMT

Move/Size checkbox allows or prevents users from moving charts or changing their size.

If the data selections result in a chart that is smaller than the max size defined, then the chart only uses the space required to display it. It will not stretch to fill the defined size unless it is in a container.

Re: Keeping straight table size fixed

NareshGuntur — Mon, 13 Jan 2014 11:21:51 GMT

You can also try unchecking Size to Data.

Cheers,

Naresh

Re: Keeping straight table size fixed

Anonymous — Mon, 13 Jan 2014 11:26:46 GMT

Use Size to Data checked in Layout tab,

This will restrict table to increase or decrease the coordinated of the charts...

Re: Keeping straight table size fixed

maxgro — Mon, 13 Jan 2014 11:27:58 GMT

Don't think

It works if you have 1 container in grid mode (1x1) for every straight table; only the str.. table is in the container; other objects remains outside the container.

The grid container has not tab.

Re: Keeping straight table size fixed

sujeetsingh — Mon, 13 Jan 2014 11:32:51 GMT

Nitin is right just check this option

Re: Keeping straight table size fixed

rsdhavle — Mon, 13 Jan 2014 11:36:07 GMT

Size to data does not make any difference. I have already tried that

Re: Keeping straight table size fixed

jagan — Mon, 13 Jan 2014 11:43:05 GMT

Hi Rohan,

Disable Size to Data option in Chart Properties -> Layout tab.

Regards,

Jagan.

Re: Keeping straight table size fixed

rsdhavle — Mon, 13 Jan 2014 11:45:16 GMT

Hi Jagan,

I tried that still it does not work..column size changes

Re: Keeping straight table size fixed

jagan — Mon, 13 Jan 2014 11:50:03 GMT

Hi,

There is no option to restrict column size, based on the data qlikview dynamically sets the column width. Size to data is for fixed Table size.

If your entire column has fixed number of characters then column size won't changes.

Regads,

Jagan.

Re: Keeping straight table size fixed

jagan — Mon, 13 Jan 2014 11:57:03 GMT

Hi Rohan,

Click on the Row Header between the two cells, the width will adjust based on your data, so that width wouldn't change.

Right click on the table and select

FIT Column to Data option

Regards,

Jagan.

Re: Keeping straight table size fixed

Anonymous — Fri, 14 Feb 2014 13:58:28 GMT

Hello Rohan,

even if this post is a little older, I want to tell you my experience and workaround. I had the same problem with a straight table. I got 40 dimensions and just 2 expressions and my table width was more than 3500 px. I tried all the things that were mentioned here but nothing worked.

So I found out that it is not possible to decrease the size of a straight table when the reason for the width are the dimensions. So I changed my table into a table with just 5 dimensions and 37 expressions. I just put any dimension in an expression. And after that i could move the size.

Maybe it's a workaround for you as well.

Best regards.

Theresa

Re: Keeping straight table size fixed

Fri, 23 May 2014 11:01:22 GMT

Hi Jagan,

I'm facing problem with straight table.

I have created a straight table with 2 dimensions and one expression.

When I select any value's(row) in straight table, it automatically shrinks to that particular selection.

I want, it has to be selected, but not to be shrink, it has to show all the values.

Is there any possibility for this.

Thanks in Advance.

Regrads,

Pavan.

Re: Keeping straight table size fixed

jagan — Fri, 23 May 2014 11:04:51 GMT

Hi,

Uncheck Size to Data in Layout tab. Hope this is what you expects.

Regards,

jagan.

Re: Keeping straight table size fixed

inescastelhano — Mon, 08 Jun 2015 16:31:02 GMT

This worked for me! Thanks !