7 Replies Latest reply: Apr 9, 2015 2:13 AM by Girish Qlik RSS

    Logic Help

    khasimvali shaik

      Hi Community,

      Need for some logical help required on script level.

       

      Requirement:

      1) One day (e.g 31 May) Complaint no  search on last 90 days(02 Mar to 30 May) data.

      Status: Done through apply map.

       

      2) One Day Filter Data have one Column Region_Name and please check below with Example.

       

       

      One Day Filter Data

      Call_id

      Region

       

      101

      Aisa

       

      102

      Europe

       

      103

      India

      Last 90 Day data

      Call_id

      Region

       

      101

      India

       

      102

      Europe

       

      103

      Aisa

       

      Output Required:

      When I select on One day Data Region:

       

      1) First Selection on One Day Filter Data: Aisa

      Output Required: No Result Found.

       

      2) Second Selection on One Day Filter Data: Aisa, Europe

      Output Required: 102 Found

       

      3) Third Selection on One Day Filter Data: India

      Output Required: No Result Found.

       

      I am post sample data. Call Id Match but Region is change and data should be filtered on basis of Region.

       

      Kindly help on this and how to solve this on script.




      Regards,

      Khasim