Fractile - QlikView

[satishkurra]

Hi

I'm facing issue in displaying the chart for < 95 percentile values.

Attached is the data, i have for Record Id, Revenue. Gross Margin % is a calculated field in the expression (Gross Margin/Fee Revenue)

I also have expressions for Revenue and Gross Margin % as

Revenue:

Sum({<FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}[Revenue])

Gross Margin %:

Avg({<FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}[Gross Margin])

/

Avg({<FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}[Fee Revenue])

I need to display the chart only for < 95 percentile values.

Can someone help me on the same.

[satishkurra]

Hi Sunny

I see scatter plot too.

All the bubbles are at the same position.

Is there a way to include values in chart with only < 95th percentile values?

Thanks

Satish

[sunny_talwar]

Same position?

[satishkurra]

I mean close to Zero. If we get the values of 95th percentile, may be we get better distribution across the chart?

[sunny_talwar · Accepted solution]

Assuming you want below 95% by Bookings $... try these two expression

Sum({<ID = {"=Sum([Bookings $]) <= Fractile(TOTAL Aggr(Sum([Bookings $]), ID), 0.95)"}>}[Bookings $])

Sum({<ID = {"=Sum([Bookings $]) <= Fractile(TOTAL Aggr(Sum([Bookings $]), ID), 0.95)"}>}[Pipeline $])

[satishkurra]

Thanks Sunny.