Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
'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?
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.
I am getting confused with how the data is structured. Do you have a sample you can share?
Thanks Sunny, let me work on a sample application and will post it
Regards
Sunny, please find attached sample application.
Regards.
Sunny seems sample was not attached
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?
Thanks Sunny, this where i was getting it wrong. Let me relook at it and advise accordingly
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?