Solved: Use of If(Not Match) function with a second restri... - Qlik Community

Anonymous · ‎2015-12-16

I have the following multi box:

I am restricting values displayed in this multi box with the following expression:

=If(Not Match(_View, 'Patent Analytics', 'FDA Analytics', 'Generic Products Opportunity Analysis', 'Shopping Analytics', 'Pharmacy Analytics'), _View)

This gives the following restricted values in the multi box:

I now want to add a second restriction to the expression as follows:

'PATENTS' < 0

I only want the values to be restricted by the if(Not Match) function when the field 'PATENTS' < 0

How can the two expressions be combined to give the desired result?

Regards.

HirisH_V7 · ‎2015-12-17

Hi ,

You haven't mapped your Dashboard(Field) with Patents(Field),

Back end :

View:

LOAD * Inline [

_View

Dashboard ,PATENTS

Point in Time Reporting,0

Leading Therapeutic Classes (Level 1),0

Leading Therapeutic Classes (Level 3),1

Leading Companies,0

Leading Products,0

Leading New Products,1

Payment Method Summary,0

Co-payment Summary,0

Fastest Growing Therapeutic Classes (ATC3),1

Comparative Analysis,1

Trend Analysis,0

Product Analytics,0

Generic Products Opportunity Analysis,1

Patent Analytics,1

FDA Analytics,1

Shopping Analytics,1

Pharmacy Analytics,0

];

//Use this at back end where Len(PATENTS)

>0 if you dont want 0 patents or else check out front end

and

ANALYTICS:
Concatenate(View)
LOAD PATENTS,
    FDA,
    GENERICS,
    SHOPPING,
    PLAZA_ANALYTICS
FROM
[..\Data Files\SectionAccess.xlsx]
(ooxml, embedded labels, table is SectionAccess);

There by mapping is done

Front end:

You can Use this expression:

=if(len(PATENTS)>0 ,If(Not Match(_View, 'Patent Analytics', 'FDA Analytics',
'Generic Products Opportunity Analysis', 'Shopping Analytics', 'Pharmacy Analytics'), _View))

Hope this Helps,

PFA,

REgards,

Hirish

HirisH

View solution in original post

sunny_talwar · ‎2015-12-16

'PATENTS' is a field from your database? also what happens when PATENTS > 0, then you won't check for If(not Match ...) or you won't allow anything if PATENTS > 0?

Anonymous · ‎2015-12-16

Thanks Sunny, 'PATENTS' is a field from a loaded Excel file. When PATENTS > 0, then all values in the multi box should be displayed.

I hope this is in order.

sunny_talwar · ‎2015-12-16

I am getting confused with how the data is structured. Do you have a sample you can share?

Anonymous · ‎2015-12-16

Thanks Sunny, let me work on a sample application and will post it

Regards

Anonymous · ‎2015-12-16

Sunny, please find attached sample application.

Regards.

Anonymous · ‎2015-12-16

Sunny seems sample was not attached

sunny_talwar · ‎2015-12-16

Chris, within your attached sample _View is coming from an island table and not really related to PATENT. How are you hoping to restrict using PATENT? I guess what is your expected output?

Anonymous · ‎2015-12-16

Thanks Sunny, this where i was getting it wrong. Let me relook at it and advise accordingly

Anonymous · ‎2015-12-16

Hi Sunny

Further to my last posting, is there a way i can associated the _View table to the USERID or the NTNAME so that these will be associated through the user authentification?

Use of If(Not Match) function with a second restriction.