Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Aika
Contributor III
Contributor III

Pivot Table

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?

pivot-table.jpg

2 Replies
NitinK7
Specialist
Specialist

try once to add year column like below exp

=Aggr(only({<year=-{'2019'}>}year),year)

and uncheck include null values box

Aika
Contributor III
Contributor III
Author

Thank you, it works!