Set Analysis with Parameter (Filters as variable)

Anonymous — Fri, 21 Dec 2018 07:08:23 GMT

List Of Variables:

1. vMarineHRExp:

pick(match($(vMarineHR), 1, 2, 3,4)
//Recruitment
, count({<[MHR._SourceFlag]={'Recruitment'},MHR.STATUS={'APPROVED'}
, $1
>} distinct MHR.map_id)
,//Promotion
count({<MHR._SourceFlag={'Promotion'}
, $1
>} distinct MHR.CPM_ID)
,//Resignation
Count({<MHR.STATUS ={'FINALISED'},[MHR._SourceFlag]={'ResignationDismissal'},MHR.CTE_TYPE={'RESIGNATION'}
, $1
>} distinct MHR.CrewID)
,
//Dismissal
Count({<MHR.STATUS ={'FINALISED'},[MHR._SourceFlag]={'ResignationDismissal'},MHR.CTE_TYPE={'DISMISSAL'}
, $1
>} distinct MHR.CrewID)

)

2. vMarineHRPeriodFilter:

pick(match($(vMarineHRFlag), 1, 2, 3)
,//Current month
'CalendarPeriod={$(=max(CalendarPeriod))}'
,//YTD
'CalendarYear={$(=max(CalendarYear))},CalendarPeriod={"<=$(=max(CalendarPeriod))"}'
,//Rolling 12 months
'CalendarPeriod={">=$(=vLast12Month) <=$(=vCurrentMonth)"}'

)

and added set analysis as

=$(vMarineHRExp(vMarineHRPeriodFilter))

just wanted to change my filter condition based on user input (filter can be : cureent month / YTD/Rolling 12 months)

so i have created vMarineHRPeriodFilter variable to finalize my filter and use this in my parameter set analysis vMarineHRExp

but its not working properly ... 😞

Re: Set Analysis with Parameter (Filters as variable)

albert_guito — Fri, 21 Dec 2018 08:55:27 GMT

Hi,

Try to expand the variable with the parameter ...

=$(vMarineHRExp($(=$(vMarineHRPeriodFilter))))

Ag+

Re: Set Analysis with Parameter (Filters as variable)

Anonymous — Fri, 21 Dec 2018 09:20:17 GMT

Thank u Albert 🙂

Its Working Now

topic Re: Set Analysis with Parameter (Filters as variable) in App Development

Set Analysis with Parameter (Filters as variable)

Re: Set Analysis with Parameter (Filters as variable)

Re: Set Analysis with Parameter (Filters as variable)