0 Replies Latest reply: Sep 15, 2016 2:32 AM by Chris Ellingworth RSS

    Set Analysis

    Chris Ellingworth

      Hi, I have data that shows employment placements

      The job seekers may be Stream A, B, C or V (depending on their likelihood of being able to find work)

      If the job seeker is in Stream A then I don't want to count them if their Stream Commencement Date is less than 91 days (in the expression below I currently have this hard wired to 5/09/2016 but I want to use the Today () function in the future.

      I have a filter pane in my Qlik Sense app that chooses between A, B, C or V.

      The expression below also looks at whether these job seekers have a Provider Brokered Flag set to yes or not and should only count the ones set to "Y".

       

      I am getting tangled up here. The expression below works fine if just Stream A is selected but doesn't work if other Streams are also selected. I am trying to avoid an enormous expression.

       

      if(Stream_Placement_Type='SA',count({<Provider_Brokered_Flag={'Y'}>}Provider_Brokered_Flag)-count({<Stream_Placement_Type={'SA'},Provider_Brokered_Flag={'Y'},Stream_Commence_Date={'>=$(=date('05/09/2016'-91,'DD/MM/YYYY'))'}>} Provider_Brokered_Flag),count({<Provider_Brokered_Flag={'Y'}>}Provider_Brokered_Flag))

       

      I have tried doing this a number of ways but not getting the result I'm after.

       

      Thanks.