topic Re: To reduce row height in QlikView

To reduce row height

Fri, 07 Mar 2014 09:05:09 GMT

Hi All,

I have an excel file with descriptions of various levels like for Novice, Intermediate, Expert etc. The table has 3 columns,

1. Score,

2. Level

3. Description -- this is a free text with varying length.

I have created a table box to display the 3 fields. Now, for level 1 I have 3 points, & for level 3 and above i have description lines varying from 6 - 10 lines.

On the presentation tab of the table box, under multi line settings i have clicked on wrap text & have mentioned the cell height as 10 lines (to accommodate all lines for level 4 & 5).

Now on level 1 & 2 i have only 3 lines, so the cell height looks really big, if i reduce the cell height to 5, lines on other levels will be missed.

What is the best solution to display this. Can the cell height be made dynamic or adjusted. Data would not be changed also. Its a fixed data.

thanks

Re: To reduce row height

alexandros17 — Fri, 07 Mar 2014 09:10:08 GMT

I think there isn't solution for that problem, height is automatically set ....

Re: To reduce row height

Fri, 07 Mar 2014 09:12:23 GMT

Hi Alessandro,

Height is not automatically set. I have set it manually for now. Its not looking good. So, any help to reduce row height would be helpful.

Thanks !!

Re: To reduce row height

giakoum — Fri, 07 Mar 2014 09:12:42 GMT

it is not directly possible, but maybe any of the following will prove helpful :

Dynamic Cell / Row / Line Height

Re: Row height in straight table

Re: Macro for increasing row height

Re: To reduce row height

alexandros17 — Fri, 07 Mar 2014 09:19:46 GMT

You're right, I expressed in a bad way, I meant that if you set height, is for the whole object not for selected rows

Re: To reduce row height

Fri, 07 Mar 2014 09:22:41 GMT

Hi Ioannis,

Since its not possible directly. I would take one of the tip from the links provided.

Thanks a lot !!