Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i was wondering if there is an option where you can hide or unhide columns in a Qlik Sense pivot table. In excel your have this feature by grouping columns and then the "+" appears to expand/unhide the columns. Is there a similar feature in Qlik?
You can conditionally show/hide dimensions or measures. There is no functionality for ad-hoc collapsing/hiding/grouping of measures, but dimensions do come with the option to expand or collapse, obviously.
Hi, Thank you for the response.
So, we can't hide/unhide the columns in the UI part as the Excel sheet, Is there any extension or third party.
You can hide measures or dimensions using show/hide rules. These can be tied to a button/variable input/selection. For some extensions, you can more easily modify the columns included in the pivot table, but ultimately this isn't Excel.
Thank you. Can you please let me know the extension that can be used.