topic Re: Classify based on in-app user selection in QlikView

Classify based on in-app user selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am having trouble with an app where the user can select a region where the customer originated then see if the customer used a facility in their region. Here is an example dataset :

LOAD Facility.Region, Customer.Region, Volume inline [

Facility.Region, Customer.Region, Volume

1, 1, 100

1, 2, 200

1, 3, 300

2, 2, 200

2, 4, 300

3, 1, 300

3, 3, 400];

The desired out come is classifying a facility as 'In' our 'Out' of market based on the user selection of the customer region.

Example: user selects customer region = 2 then facility region 2 classified as 'In' and facility region 1 & 3 as 'Out'. My problem is that facility region 2 get classified as both 'In' and 'Out' when I use if(customer.region = facility.region, 'In','Out'). I am not sure where to begin if set analysis is the best way.

Re: Classify based on in-app user selection

Miguel_Angel_Baeyens — Thu, 22 Feb 2018 14:08:17 GMT

What are the criteria to keep in or out? If a value is the same in both fields, it is both In and Out, unless you apply additional filters

Re: Classify based on in-app user selection

Mark_Little — Thu, 22 Feb 2018 14:19:53 GMT

Hi Ryan,

Like Miguel has suggested some more information would be great on the logic defining in and out.

If you just want to get the Facility.regoin that matches a selected value try something like

if( facility.region = GetFieldSelections(customer.region), 'In','Out').

Mark

Re: Classify based on in-app user selection

Anonymous — Thu, 22 Feb 2018 16:44:43 GMT

the criteria for 'In' is if the facility region is 'In' the list of customer regions that the user has chosen.

Re: Classify based on in-app user selection

Anonymous — Thu, 22 Feb 2018 17:18:21 GMT

I think I got it, but other please feel free to evaluate:

aggr(max(if(facility.region = customer.region,1,0)),facility.region)

if others have suggestion to refine the approach I am interested.