Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=if(Month(created_date) = Month(Max(Date)) ,count({<status={'New'}>}reports) )