Issue with set analysis to find the YTD result with filter on a different date field

[fashid]

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

[Anil_Babu_Samineni]

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)

[fashid]

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

[Anil_Babu_Samineni]

May be i am not following you, Can you share application

[sunny_talwar]

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?