Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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!