Set Analysis for month conditions

[Prasad1318]

Dear all,

I am new to qliksense.

I have a pivot table with the Monthyear as dimension and Status as one more dimension.

In Monthyear , I am showing last 3 months

In status field , I have values - New, Closed, In progress.

I need to calculate, count of reports based on conditions for each status.

For ‘New’ - count(reports), if created_Date(dd/mm/yyyy) = reporting Monthyear. For eg , if a report is created in month of april then it should count in status ‘new’ and monthyear - April-2022.

Can somebody help me in writing set analysis for above problem. I can take reference for ‘ New’ and work on other status

Thank you in advance.

[vinieme12]

=if(Month(created_date) = Month(Max(Date)) ,count({<status={'New'}>}reports) )