Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

I have the following multi box:

Screen Shot 2015-12-16 at 23.04.07.png

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:


Screen Shot 2015-12-16 at 23.04.36.png

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.



1 Solution

Accepted Solutions
HirisH_V7
Master
Master

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

18 Replies
sunny_talwar

'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
Not applicable
Author

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

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

Anonymous
Not applicable
Author

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

Regards

Anonymous
Not applicable
Author

Sunny, please find attached sample application.

Regards.

Anonymous
Not applicable
Author

Sunny seems sample was not attached

sunny_talwar

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
Not applicable
Author

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

Anonymous
Not applicable
Author

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?