expressions of box plot

[zied_ahmed1]

Hello,

I used a box plot and I have these results :

Now I would like to have the expressions for all (Min,Max,first quartile,Mediane..etc ) I choosed the Percentile-based to define it

Thanks for help omarbensalem‌ stalwar1‌

[OmarBenSalem]

Min , max could be calculated using the min/max functions (their use depends on ur case)

to be able to have the quartiles; u'll have to use the Fractile() method:

here's a link found in the qlik's help site that could guide u through this:

Fractile - fonction de graphique ‒ Qlik Sense

and here's a link for the median:

Median - fonction de graphique ‒ Qlik Sense

[zied_ahmed1]

Thanks for help,

My expression is :

(sum(CALLSANSWERED) - sum(CALLSANSWEREDAFTTHRESHOLD))

/

sum(CALLSANSWERED)

When I try to add functions like Min or Max or Fractile they don't work , also i used variables for every sum and i have the same problem

[pradosh_thakur]

have you tried using max(aggr(sum()) . aggregating the aggregation function won't work unless you are using the AGGR Function.

[zied_ahmed1 · Accepted solution]

Hello,

I find the solution :

Median(aggr((sum(CALLSANSWERED) - sum(CALLSANSWEREDAFTTHRESHOLD))/sum(CALLSANSWERED), DateCal))

Min(aggr((sum(CALLSANSWERED) - sum(CALLSANSWEREDAFTTHRESHOLD))/sum(CALLSANSWERED), DateCal))

Max(aggr((sum(CALLSANSWERED) - sum(CALLSANSWEREDAFTTHRESHOLD))/sum(CALLSANSWERED), DateCal))

Thanks for all