Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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

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

Tags (1)
4 Replies
Highlighted

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

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Specialist
Specialist

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

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

Highlighted

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

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

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?