Min on a dimension with set analysis

[berndjaegle]

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]

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

[berndjaegle]

Gives no result. Also tried MIN arround the statement.

[agigliotti · Accepted solution]

Hi @berndjaegle ,

what about this expression:

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

I hope it can help.

Best Regards

[berndjaegle]

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

Best regards,

Bernd