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

[QlikEnthu1]

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

[Chanty4u]

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