Qlik Sense Show/Hide columns from cross or pivot table structure

QlikEnthu1 — Fri, 15 Nov 2024 21:47:17 GMT

How do you show and hide columns in the table present on Qlik Sense front end as shown below, using filters like Year, Month, Quarter? The table has customer, month and sales amount data and 36 columns from Jan-21 to Dec-23. Assume the Date Master table is present.

Example - If Year=2022 is selected in the filter then only the columns for year 2022 should be shown and rest should be hidden. Same goes for Month filter where the selected months should show in the table and rest should be hidden.

Customer	Jan-21	Feb-21	Mar-21	…….	Dec-23
Name	100	200	300		200

Re: Qlik Sense Show/Hide columns from cross or pivot table structure

Chanty4u — Fri, 19 May 2023 17:40:25 GMT

In the "Show column" field, enter a conditional expression that evaluates whether the column should be shown or hidden based on the selected filters.

For example, to show only the columns for the selected Year, you can use the following expression:

=Year(Date) = Only({<Year=>} Year)

Use same for all the fields

topic Qlik Sense Show/Hide columns from cross or pivot table structure in App Development

Qlik Sense Show/Hide columns from cross or pivot table structure

Re: Qlik Sense Show/Hide columns from cross or pivot table structure