Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
sinduabi
New Contributor

Can we export limited number of columns to PDF?


I have a table with 50 columns. I have to export only 10 columns to PDF. Is it possible to do? Can someone help on it.?

6 Replies
MVP & Luminary
MVP & Luminary

Re: Can we export limited number of columns to PDF?

Most often it's very helpful to use different objects for displaying within dashboards and other reports and which will be printed or exported. In any case you need an additionally logic to reduce the number of columns - this could be within a single object visibilty-conditions maybe triggered per buttons which set a variable-value ...

- Marcus

sinduabi
New Contributor

Re: Can we export limited number of columns to PDF?

Hi Marcus,

  It would be really helpful if you are to share an example..

vikasmahajan
Esteemed Contributor

Re: Can we export limited number of columns to PDF?

Hii,

you can create report using straight table drag & drop this chat in qlikview report and via macro you can transfer this objects with 10 columns into pdf.

Hope this may help you .

Vikas

qlikmsg4u
Valued Contributor

Re: Can we export limited number of columns to PDF?

So your table having 50 columns but you want create report with only 10 columns then

The easiest way is create another table with only required 10 columns and use this newly created table to generate report.

MVP & Luminary
MVP & Luminary

Re: Can we export limited number of columns to PDF?

I haven't a sample which I could easily share here but with different objects it's quite easy to implement this.

Create a new sheet named with print+exports which contained all your objects which are intended to be printed or exported. From your origin objects you makes a copy, put in that sheet and customize it - maybe per removing or deactivating from dimensions and expressions and maybe some more. If this printing/exporting isn't aimed for (all) user inter-activity you could simply hide this sheet per conditions like if(match(osuser(), 'user1', ... and use their object-id's within your actions and macros.

- Marcus

vardhancse
Valued Contributor III

Re: Can we export limited number of columns to PDF?

Yes, adding to Marcus Sommer , Create one sheet-> s straight table with limited number of rows(as required)

Create one report from menu options, drag and drop the new straight table from the new sheet with limited number of rows.

Now when ever we want a pdf report with only some 10 records we can get using the report