How to show open PR's status month wise ( in Chart )

[chandrajakkula]

Hi All,

We are trying to show The line Chart month wise which shows the count of open PR's at each month end.

and we are trying to write below expression but its not working please help.

=count({1<PR_Close_Date={">$(=date((monthend(max(Month_Year))),'DD-MM-YYYY'))"},

PR_Creation_Date={"<=$(=date((monthend(max(Month_Year))),'DD-MM-YYYY'))"} >} PR_NO)

Thanks In advance..

[jwaligora]

Not a direct answer, but you may wish to check this out: https://community.qlik.com/t5/QlikView-Creating-Analytics/How-to-display-number-of-open-cases-in-a-m...

[Brett_Bleess]

In addition to above poster, try the following links as well, but if the above helped, be sure to mark that as the solution using the Accept as Solution button.

Set Analysis Help:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Design Blog:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

There are some additional links at the bottom of that post, just FYI, one directly related to dates and set analysis that you likely want to check as well.

Regards,
Brett