topic Re: Hide dimension in Excel export in App Development

Hide dimension in Excel export

jbrodmann — Sat, 16 Nov 2024 05:27:07 GMT

Hello,

please say is there any chance to hide a dimension of a normal table in Qlik Sense?

I use a numeric ID as Dimension and don't want to append this to the Excel export of the table.

I tried to use calc conditions, they are working just fine for measures but not for dimensions.

Maybe someone has a nice idea or workaround for this?

dplr-rn — Thu, 27 Jun 2019 16:46:45 GMT

Did you try the 'Show Column If' on the dimension? just set your condition there

rubenmarin — Thu, 27 Jun 2019 18:55:38 GMT

Hi, you can try usign another field with Dual

Dual(TextField, Numberfield)

If it's only for sorting you can try sorting by expression

jbrodmann — Fri, 28 Jun 2019 08:38:53 GMT

Thank you for your fast answers.

No unlikely this doesn't work on dimensions. The rest of the Table will be grouped, like if the column not exists.

This is a nice approach. Using Dual to hide the interlnal ID works pretty good!

shloime — Sat, 11 Sep 2021 18:47:04 GMT

The LogiExport extension can be used to achieve this functionality and much more In a very elegant and easy way.

Search for "Hide column" in the documentation.