Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
berndjaegle
Creator II
Creator II

Min on a dimension with set analysis

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.

Qlik Sense_aggr_min_on_Calendar.png

 

 

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])

Labels (2)
1 Solution

Accepted Solutions
agigliotti
Partner
Partner

Hi @berndjaegle ,

what about this expression:

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

I hope it can help.

Best Regards

View solution in original post

4 Replies
lironbaram
Partner
Partner

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

berndjaegle
Creator II
Creator II
Author

Gives no result. Also tried MIN arround the statement.Qlik Sense_aggr_min_on_Calendar_2.png

 

agigliotti
Partner
Partner

Hi @berndjaegle ,

what about this expression:

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

I hope it can help.

Best Regards

View solution in original post

berndjaegle
Creator II
Creator II
Author

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

Best regards,

Bernd