topic Listbox in PDF Reports in QlikView

Listbox in PDF Reports

Tue, 08 Sep 2015 10:12:25 GMT

Hi, all!

I need to generate a PDF report, which includes a list box called Index with more than 1000 records. I simply drag the list box in the Report Editor, but instead of showing all records, it only shows one column. I did settings in: 1) List Box Properties---> Presentation--->Fixed Number of Columns (to '10' !!!); and 2) Item Setting---> Stretch (to 'Clip' !!!). How can I make all records listed? Any help or suggestion would be appreciated.

Regards, Luwen

Re: Listbox in PDF Reports

marcus_sommer — Tue, 08 Sep 2015 13:02:23 GMT

I don't believe that this is possible - the capabilities from report-editor are unfortunately (more or less) restricted. Therefore you will need some kind of workaround - the easiest way seems to be to use a textbox with an expression like: = concat(distinct num(%ID, '00000'), chr(9) & '|' & chr(9), %ID) which you might need to modify the delimiter or the font or other layout-options from the textbox to make it suitable for your report.

Table-Chart solutions might be possible too, especially if there are some precalculations within the script.

Another option is to use tools like NPrinting: QlikView NPrinting.

- Marcus

Re: Listbox in PDF Reports

Wed, 09 Sep 2015 08:49:53 GMT

Hi, Marcus!

Thanks for the reply. It's very helpful. I tried to use a textbox, and it worked.

Luwen