Exclude fields from exported csv

[mfarr13]

Hi all,

Is it possible to exclude a couple of fields from the exported csv when exporting data?

Say I have a table on a sheet with 10 fields, however, I would like to allow the user only to export 8 out of those 10 fields but they should still be able to view all 10 fields on the sheet itself (through Qlik Sense).

The user cannot choose which 2 fields to exclude, the fields would have to have been selected beforehand by an admin through scripting / qmc etc...

Scenario: User wants to export table data from sheet containing 10 fields

Output: User gets csv with 8 out of those 10 fields.

[rubenmarin · Accepted solution]

Hi, I don't know a way to omit fields from export.

If this is because the user don't want the fields you can add a button to hide/show those columns using conditional show.

If it's because of an admin restriction that you don't to allow users to export that fields it gets more complicated. By default the ExportAppData allows everyone to export data.

One option could be to change this rule to work by App* instead of App_* so you can set specific rule by AppObjects, and add a prefix or suffix to the sheets you dont want the users to export data.

With this rule you can have the table with 10 fields in the sheet with the prefix or suffix to not allow export, and the table with 8 columns in another sheet that allows exports.