Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jbrodmann
Partner - Contributor II
Partner - Contributor II

Hide dimension in Excel export

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?

Labels (2)
1 Solution

Accepted Solutions
rubenmarin

Hi, you can try usign another field with Dual

Dual(TextField, Numberfield)

 

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

View solution in original post

4 Replies
dplr-rn
Partner - Master III
Partner - Master III

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

rubenmarin

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
Partner - Contributor II
Partner - Contributor II
Author

Thank you for your fast answers.

@dplr-rn 

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

 

@rubenmarin 

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

shloime
Contributor III
Contributor III

 

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

More details are in the following link:
https://logiexport.logsys.co.il/documentation/

Search for "Hide column" in the documentation.