Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted

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

3 Replies
Highlighted
Partner
Partner

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

Highlighted

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

Highlighted
Partner
Partner

Thank you for your fast answers.

@dilipranjith 

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!