topic Re: Export some table columns only in QlikView

Export some table columns only

danosoft — Tue, 15 Oct 2019 13:21:12 GMT

I need to export .csv or .xls of an object table (note is a table not a straight table chart).

I want my export have only some columns (4,5 columns) not all 50 columns, is possible?

thanks

Re: Export some table columns only

m_woolf — Tue, 15 Oct 2019 17:25:17 GMT

I suggest making a table with just the columns you want to export.

Re: Export some table columns only

danosoft — Wed, 16 Oct 2019 06:34:06 GMT

sorry this not a solution, sure i can do it and i thought about that, but i ask if it can be do with a table withouth create another element

Re: Export some table columns only

StarinieriG — Wed, 16 Oct 2019 08:04:14 GMT

Hi,

you could add condition to each column.

For example:

vColumn=1 or vColumn=' ' for columns that you want to show

vColumn <> 1 for column that you don't want to show

Than create a button that:

1) set vColumn = 1

2) export table

3) set vColumn = ' '

Re: Export some table columns only

danosoft — Wed, 16 Oct 2019 08:07:46 GMT

no i can't do that, becouse, like i wrote: "note is a table not a straight table chart" so not have a possibility to put a condition

Re: Export some table columns only

Brett_Bleess — Tue, 22 Oct 2019 12:58:03 GMT

Daniele, I agree with Mike on this one, the best option you have is to create another Table Box object with just the two columns to perform the export you want, as there is no means to just export 2 columns from the larger one as far as I know. You could use a Button with an action to do things and maybe hide the smaller Table Box from the users, but that is the best I have.

Regards,
Brett