Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi, you can try usign another field with Dual
Dual(TextField, Numberfield)
If it's only for sorting you can try sorting by expression
Did you try the 'Show Column If' on the dimension? just set your condition there
Hi, you can try usign another field with Dual
Dual(TextField, Numberfield)
If it's only for sorting you can try sorting by expression
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!
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.