Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Listbox in PDF Reports

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

1 Solution

Accepted Solutions
marcus_sommer

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

View solution in original post

2 Replies
marcus_sommer

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

Not applicable
Author

Hi, Marcus!

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

Luwen