Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pthomas3253
New Contributor II

Aggregated Minimum Value for each month

I am trying to show the Minimum value in a field if a criteria is met aggregated by each month. Right now the minimum across the data set is what is pulling in my bar graph for each month, but I need those to be aggregated to change based off of the minimum for that month only.

I'm currently using the below to pull the minimum Layer number if the for all records that have "Manager" in as the criteria. This is currently showing me 4 for every month - however, May should have 5 since there is no one in that month that meets that criteria - but I'm still showing 4. Any help is greatly appreciated!

=Min(if([Rolling12_HC.Manager? Y = 1]='Manager',[Rolling12_HC.Number of Layer]))+1

1 Reply
MVP
MVP

Re: Aggregated Minimum Value for each month