Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Logic Help Required

Dear Friends,

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 DataCall_idRegion
101Aisa
102Europe
103India
Last 90 Day dataCall_idRegion
101India
102Europe
103Aisa

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

Ravi Gupta