Hide Technical Dimension from Exported Excel While Retaining Table Logic
I have a Qlik table where a technical dimension (ProductDRSKey) is required for the current table logic and calculations. As a result, when users export/download the table data to Excel, this field is also included in the exported file.
Our business users would prefer not to see this technical field in the Excel export because it is only used internally and adds unnecessary data to the downloaded file.
I investigated a few options, but since the field is used as a dimension for the existing implementation, removing or hiding it appears to affect the current logic.
My question is: Is there any supported approach in Qlik Sense to:
Keep a dimension available for internal table logic
Prevent that dimension from appearing in exported/downloaded Excel data
Or hide/mask the column only in the export without impacting existing functionality
Has anyone encountered a similar requirement or found a workaround?
As far as I know, Since ProductDRSKey is used as a dimension in the table, Qlik includes it in the exported data. Keeping the field for internal logic while excluding it only from the Excel export is not supported out of the box. Retaining the current logic means the field will also remain in the export.
There might be ways to transfer this dimension to other dimensions and/or to include it within the calculations - for example with a calculated dimension like: dual(Product, ProductDSRKey) and/or something like: aggr(concat(distinct ProductGroup, ' + '), ProductDSRKey) and/or aggr() are applied within the expressions to respect a certain dimensionality.
Be aware that such measurements could result in quite complex approaches and may cause side-effects to the usability and performance.
