topic Re: Row height in straight table in QlikView

Row height in straight table

pauldamen — Fri, 06 Dec 2013 13:13:03 GMT

Hi all,

I have a very simple question but can't find the answer. I have a straight table with 3 columns, 1 column contains a text description.

What I need is that the row height is adjusted according to the text, so if the text is 2 lines it should be 2, if the text is 5 lines it should be 5.

I know the Wrap Cell Text option, but this only allows me to enter a fixed height and I need it to be dynamic.

Any one has a solution for me?

Regards,

Paul

Re: Row height in straight table

stevedark — Fri, 06 Dec 2013 14:13:20 GMT

Hi Paul,

As far as I know you can't have a different row height on different rows of a table. You just need to set the number of rows to a value sufficiently big to show most of the values you have. The rest of the text can be shown by hovering over the cell and viewing the tool-tip.

If this is for static reporting you may want to look at a tool that will send the output to Excel as this does the dynamic cell height you describe. NPrinting is a very good option for this.

Hope that helps,

Steve

Re: Row height in straight table

fred_s — Fri, 06 Dec 2013 14:49:48 GMT

Hi Paul,

Had the same issue with a 'knowledgebase'.
I've choosen to show 3 lines default and show the complete story in a textbox after selecting one unique record.

See attachment

Re: Row height in straight table

stevedark — Fri, 06 Dec 2013 15:19:09 GMT

Another nice trick when you have a single row selected is to toggle from having one row of data in a table to showing column headings down the left hand side then data values to the right - allowing much more space for detail.

To do this you need to take a copy of your Straight table and set Show Conditions on both tables. One reading:

=GetPossibleCount(IDField) = 1

And the other (you've guessed it):

=GetPossibleCount(IDField) <> 0

On the Straight Table that shows when only one value is selected go to the Properties and the Presentation tab and then tick the Horizontal option. You will also want to turn off all totals on the expressions of this version.

Steve

Re: Row height in straight table

pauldamen — Tue, 17 Dec 2013 12:43:44 GMT

Hi Guys,

Thanks for the help and all the solutions. Thing is I need it for creating a report and be able to print it. So "clicking" solutions are unfortunatly not an option.

But not possible is also an answer

Regards,

Paul

Re: Row height in straight table

stevedark — Tue, 17 Dec 2013 12:55:16 GMT

Hi Paul,

It may be overkill for what you are after, but if you need to format output for printing you may want to look at NPrinting. This allows you to format an Excel template and then populate it with data from QlikView. Setting cells to auto expand would then be possible.

For more details please see http://www.quickintelligence.co.uk/nprinting/

Cheers,

Steve

Re: Row height in straight table

christian77 — Wed, 18 Dec 2013 16:08:19 GMT

Hi.

Break your free text into equal pieces like 30 chars. Load a record for each piece. Make cell borders transparent. add a desing like a pajama every change in Record_id dimensión.

Luck.