topic expressions of box plot in Management & Governance

expressions of box plot

zied_ahmed1 — Fri, 29 Dec 2017 09:45:40 GMT

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 — Fri, 29 Dec 2017 09:54:54 GMT

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:

and here's a link for the median:

zied_ahmed1 — Fri, 29 Dec 2017 10:14:33 GMT

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 — Fri, 29 Dec 2017 10:20:53 GMT

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

zied_ahmed1 — Fri, 29 Dec 2017 11:40:19 GMT

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