topic Re: Use of If(Not Match) function with a second restriction. in QlikView

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

Anonymous — Wed, 16 Dec 2015 21:20:07 GMT

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.

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

sunny_talwar — Wed, 16 Dec 2015 21:22:31 GMT

'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?

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

Anonymous — Wed, 16 Dec 2015 21:38:05 GMT

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.

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

sunny_talwar — Wed, 16 Dec 2015 21:42:15 GMT

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

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

Anonymous — Wed, 16 Dec 2015 22:01:40 GMT

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

Regards

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

Anonymous — Wed, 16 Dec 2015 22:18:54 GMT

Sunny, please find attached sample application.

Regards.

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

Anonymous — Wed, 16 Dec 2015 22:20:38 GMT

Sunny seems sample was not attached

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

sunny_talwar — Wed, 16 Dec 2015 23:05:33 GMT

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?

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

Anonymous — Wed, 16 Dec 2015 23:54:10 GMT

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

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

Anonymous — Thu, 17 Dec 2015 00:07:09 GMT

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?

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

Anonymous — Thu, 17 Dec 2015 00:39:43 GMT

HI SUNNY

If i get my model with the right associations, the expression should be something like:

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

A user with a 'PATENT' flag of 1 should be able to see the all the contents of the multi box and a user with a 'PATENT' flag of zero should only see the restricted list.

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

settu_periasamy — Thu, 17 Dec 2015 04:42:43 GMT

Hi Christopher,

Try this

=if(GetFieldSelections(PATENTS)=0,

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

, _View),_View)

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

HirisH_V7 — Thu, 17 Dec 2015 05:39:59 GMT

Hi ,

You can write like this in your back end.

Table:
LOAD * INLINE [
    View, Patents
    Patent Analytics,1
    FDA Analytics,2
    Generic Products Opportunity Analysis,
    Shopping Analytics,
    Pharmacy Analytics,4
]Where len(Patents)>0;

Output:

This will bring all the records which are having patents.

Hope this helps,

Regards,

Hirish

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

HirisH_V7 — Thu, 17 Dec 2015 06:01:48 GMT

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

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

Anonymous — Thu, 17 Dec 2015 14:12:40 GMT

Dear Hirish

Thank you very much for you input. I will work on it and advise accordingly.

Regards.

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

Anonymous — Thu, 17 Dec 2015 14:13:16 GMT

Thanks Hirish

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

Anonymous — Thu, 17 Dec 2015 14:14:57 GMT

Many thanks Settu, i will try that out

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

Anonymous — Thu, 17 Dec 2015 15:08:36 GMT

Hi Hirish

Is there a way of linking the say 'PATENT' field with Section Access so that a user with a 'PATENT' flag of say 1 within section access will be able to access the 'Patent Analytics' menu selection, a user with a 'FDA' flag of 1 will also be able to access the 'FDA Analytics' menu selection and so on?

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

HirisH_V7 — Sat, 19 Dec 2015 07:12:58 GMT

Pleasure ..

Thank u