topic Selections made in the expressions without preventing selection from the filter panes in App Development

Selections made in the expressions without preventing selection from the filter panes

Anonymous — Thu, 16 Nov 2017 11:05:18 GMT

Hi all!

In order to have a selection of data made by default, the solution I got was to select them in my expressions. For example:

Count({$<MillAlloc={"X"},AllocYear={"$(vCurrentAllocYear)"} ,AllocWeekYear={"<=$(vLastAllocWeek)"}, InternalServPfeYn={"N"},InternalServExternalPi={"N"},MarketRegionCd={'EU', 'ROE'},InternalServReadyLateDisp={"Y"}>}InternalServReadyLateDisp)/(Count({$<MillAlloc={"X"},AllocYear={"$(vCurrentAllocYear)"} ,AllocWeekYear={"<=$(vLastAllocWeek)"}, InternalServPfeYn={"N"},InternalServExternalPi={"N"},MarketRegionCd={'EU', 'ROE'}>}InternalServReadyLateDisp))

Now the problem is that I want to continue giving the user some freedom to select options in fields that I have filtered by default. For example, the user is only seeing MarketRegionCd = {'EU', 'ROE'} when he opens the application and may want to select MarketRegionCd = USA.

Do you know if this is possible?

Every help is welcome! Thank you!

Re: Selections made in the expressions without preventing selection from the filter panes

jonathandienst — Thu, 16 Nov 2017 11:23:31 GMT

You can create unions and intersections between the current selections and the set expression selections

MillAlloc += {"X"} // union of current selections and set selection "X"

AllocYear *= {"$(vCurrentAllocYear)"} // intersection of current selection and set selection

Re: Selections made in the expressions without preventing selection from the filter panes

Anonymous — Thu, 16 Nov 2017 11:42:44 GMT

Thank you Jonathan.

It seems to be working for the field selections I made in my set expression. For example, if I write MarketRegionCd * = {'EU', 'ROE'} I can see only EU or just ROE, which was not possible before, but I still can not see results for another MarketRegionCd...

Do you have any Idea what I might be doing wrong? Thank you

Re: Selections made in the expressions without preventing selection from the filter panes

Anonymous — Thu, 16 Nov 2017 12:13:10 GMT

Jonathan, now I've tried this expression MarketRegionCd += {'EU', 'ROE'} and, for this tipe of field, it seems to work better than the intersection*.

The problem is that I may not always want to continue seeing the EU and ROE market Region Cd and that's what's happening... Do you now how to solve this issue?

Thank you!