Discussion Board for collaboration on QlikView Layout & Visualizations.
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:
Go to Solution.
Try maybe something like
=min(aggr( if(DPML >= round(Fractile(total<RPT_DATE> DPML,.75),.01),DPML),RPT_DATE,DPML))