Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this pivot table in qlik. I have to remove the 2019 and 2019 columns (they are within one dimension: [transaction_date.autoCalendar.Month]).
How can I do?
try once to add year column like below exp
=Aggr(only({<year=-{'2019'}>}year),year)
and uncheck include null values box
Thank you, it works!