Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Min value over the aggregation

Hi All, I am trying to calculate the min value of the DPML (one of field) is greater than the or equal to the FRACTILE(DPML,0.75) value for that RPT_DAY.

I attached the qvw with sample data. Here below is looking for:

MIN(IF(DPML>=FRACTILE(DPML,0.95),DPML,FRACTILE(DPML,0.75)))

1 Solution

Accepted Solutions
MVP
MVP

Re: Min value over the aggregation

Try maybe something like

=min(aggr( if(DPML >= round(Fractile(total<RPT_DATE> DPML,.75),.01),DPML),RPT_DATE,DPML))

2 Replies
MVP
MVP

Re: Min value over the aggregation

Try maybe something like

=min(aggr( if(DPML >= round(Fractile(total<RPT_DATE> DPML,.75),.01),DPML),RPT_DATE,DPML))

Not applicable

Re: Min value over the aggregation

Thanks swuehl.