Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have the following expression
=count({<CATEGORY={'X'},CLASS={'NON VENDOR'},FIN_YEAR_NO={"$(vMaxYear)"},App_Date={">=$(vMinDate)"},FIN_MONTH_NO={"<=$(=max(FIN_MONTH_NO))"},Month=, App_Date= >}DISTINCT EMP_ID)
i HAVE CREATED A CHART WITH TO SHOW YTD EMPLOYEE COUNT BASED ON THE ABOVE EXPRESSION.
Everything works except the filter on App_date , the App_date filter does not work and gives the entire list of emp codes who have any app_date . what could be the issue
Regards,
Nadeem Shaikh
If you already did one time of filter no need to write again. Delete "App_Date" and then use
=count({<CATEGORY={'X'},CLASS={'NON VENDOR'},FIN_YEAR_NO={"$(vMaxYear)"},App_Date={">=$(vMinDate)"},FIN_MONTH_NO={"<=$(=max(FIN_MONTH_NO))"},Month= >}DISTINCT EMP_ID)
Hi,
Thanks for replying.
This does not work now i get results of only the month that is selected . The removal of the App_date field disables the YTD feature .
Regards,
nadeem
May be i am not following you, Can you share application
How do you define vMinDate here? Is it a static value or is it an expression which can have different values within your chart for different dimension values?