topic Re: Min on a dimension with set analysis in App Development

Min on a dimension with set analysis

berndjaegle — Tue, 21 Dec 2021 22:04:53 GMT

Hi guys,

I stuck with a simple issue... I thought it is simple:

How can i bring the Min value to all lines?

And I managed with rank to have Min value.

I have set analysis in the KPI --> {$ <[AbsAll.CODE]={'9042'}>}.

No Result:

Min(Total <[HR.PERSONALNUMMER]> Aggr(Only({$ <[AbsAll.CODE]={'9042'}>} [HR.KalenderDatum]) ,[HR.PERSONALNUMMER]))

Wrong because Min over all lines:

Min( {<[HR.PERSONALNUMMER],[HR.KalenderDatum]>} TOTAL {$ <[AbsAll.CODE]={'9042'}>} [HR.KalenderDatum])

lironbaram — Wed, 24 Mar 2021 11:50:38 GMT

hi
you can try
Aggr(nodistinct Only({$ <[AbsAll.CODE]={'9042'}>} [HR.KalenderDatum]) ,[HR.PERSONALNUMMER]))

berndjaegle — Wed, 24 Mar 2021 13:41:17 GMT

Gives no result. Also tried MIN arround the statement.

agigliotti — Wed, 24 Mar 2021 14:30:52 GMT

what about this expression:

=Min( {< [AbsAll.CODE] ={'9042'} >} TOTAL <[HR.PERSONALNUMMER]> [HR.KalenderDatum] )

I hope it can help.

Best Regards

berndjaegle — Thu, 25 Mar 2021 07:16:11 GMT

Hi agigliotti, this is it! Thanks a lot for your help! This community rocks!

Best regards,

Bernd