Tabular Reporting Filter

profilejamesbond — Tue, 11 Nov 2025 08:51:04 GMT

Hi,

Monthly Tabular Reporting

I created one Tabular Reporting. The Reporting contains 2 tabs.

Tab A

Tab B

Tab A shows the Product A and Product B for the last month (Oct2025). To filter the last month I created Filter and applied over the Send Task.

Yearly Tabular Reporting

Now, I would like to show the complete data (from 01.01.2025 to today()) for Tab B with only Product A. How to do that ?

Problem: If I remove the filter then it will show the Tab A data from 01.01.2025 to today().

Simple: How to create Monthly and Yearly Report Sheets in a same .xlsx file?

Thanks

Re: Tabular Reporting Filter

Chanty4u — Tue, 11 Nov 2025 15:15:00 GMT

In yearly tab inside qlik object use below condition

Sum({<Date={">=$(=Date(MakeDate(2025,1,1)))<=$(=Date(Today()))"}, Product={'Product A'}>} Sales)