Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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