topic Re: How to Fix Column Width in straight table in QlikView

How to Fix Column Width in straight table

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can Some One Help me , when i try to add 3 Fields in my straight table its width is creating problem.

below are the fields

Growth_Strategy_and_Innovation_Text,

Obstacles_and_Challenges_Text,

Current_Happenings_Text,

i am attaching the report for your reference. can some one help me when i add above fields my borders should not disappear and my table box width should not extend.

Best Regards,

Re: How to Fix Column Width in straight table

Sergey_Shuklin — Sun, 28 May 2017 15:55:28 GMT

Hello, HariKiran!

First of all you are using a table box instead of a straight table. Table box shows fields as they are. But field Growth_Strategy_and_Innovation_Text contains to much symbols (even hidden, like a space), so you get your "problem".

To avoid this you can use a straight table as it is. Use your text fields in expressions (at least you always have an option to use Left() function):

You also can use some string functions in the script like Trim(), Replace(), Left() for trasforming your input data.

And one recommendation (if you don't mind) - don't use such a huge tables, they are unreadable.

Re: How to Fix Column Width in straight table

dunnalahk123 — Sun, 28 May 2017 16:33:04 GMT

Hi,

Thank You. i will take a look with Straight Table as well.

So there is nothing much we can do in table Box with those Fields?

Best Regards,

Re: How to Fix Column Width in straight table

Sergey_Shuklin — Sun, 28 May 2017 17:58:38 GMT

Well, you can also use an autowidth option:

RMB click on field which width you want to use for other fields and select "Equal Column Width".

Re: How to Fix Column Width in straight table

Anil_Babu_Samineni — Sun, 28 May 2017 18:06:00 GMT

One possible solution my end is you may re constrain the field names to short then work on it as per there business to better understand

Re: How to Fix Column Width in straight table

dunnalahk123 — Sun, 28 May 2017 18:06:49 GMT

Hi,

Thank You.

You mean in table box you are asking me to Right Click on it and select Equal Column Width? but if i try to do so it is Disable for me.

or can you show me in the attached Qvw File?

Best Regards,

Hari

Re: How to Fix Column Width in straight table

Sergey_Shuklin — Sun, 28 May 2017 18:33:51 GMT

Someone had turned off parameters to move/size your table, so you get option "Equal Column Width" disabled:

I'm also attaching your file back with result.

Re: How to Fix Column Width in straight table

dunnalahk123 — Sun, 28 May 2017 18:54:48 GMT

Hi Shuklin,

Thank You so Much this is what i want.

but i took your attachment QVW and i tried to add my other 2 fields as well but again i am facing same issue it is expanding completely.

may be i am doing some thing wrong. sorry for that

Re: How to Fix Column Width in straight table

dunnalahk123 — Sun, 28 May 2017 19:04:47 GMT

After adding those fields i clicked on Equal Width but still it is like that only.

Re: How to Fix Column Width in straight table

Sergey_Shuklin — Sun, 28 May 2017 19:09:44 GMT

Unfortunately, you'll have to size columns everytime after adding a new field in that table. I've added another two column which you point, but I strongly recommend to do domething with this huge field. It brokes the project.

Re: How to Fix Column Width in straight table

dunnalahk123 — Sun, 28 May 2017 19:31:02 GMT

Hi,

Oh OK. yes doing every time is a Problem . sure i have to think of it.

Thank You so much on helping me here.

Best Regards,