https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1824781#M67749 <P>Thank you, it works!</P> Tue, 27 Jul 2021 10:46:12 GMT Aika 2021-07-27T10:46:12Z https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1823574#M67568 <P>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]).<BR />How can I do?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="pivot-table.jpg" style="width: 444px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/58927i910E4BFE616C4F4B/image-dimensions/444x196?v=v2" width="444" height="196" role="button" title="pivot-table.jpg" alt="pivot-table.jpg" /></span></P> Wed, 21 Jul 2021 10:50:58 GMT https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1823574#M67568 Aika 2021-07-21T10:50:58Z https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1823620#M67575 <P>try once to add year column like below exp</P><P>=Aggr(only({&lt;year=-{'2019'}&gt;}year),year)</P><P>and uncheck include null values box</P> Wed, 21 Jul 2021 13:01:25 GMT https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1823620#M67575 NitinK7 2021-07-21T13:01:25Z https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1824781#M67749 <P>Thank you, it works!</P> Tue, 27 Jul 2021 10:46:12 GMT https://community.qlik.com/t5/App-Development/Pivot-Table/m-p/1824781#M67749 Aika 2021-07-27T10:46:12Z