Fractile QlikView

[satishkurra]

Hi

I'm currently using below expression to get the Revenue >=95 % values

This is working fine.

Now the ask is how to modify this expression to show values between 5 and 95 % values.

Please help

Expression:

=Sum({<RecordID =

{"=Sum([Revenue])

<= Fractile(TOTAL Aggr(Sum([Revenue]), RecordID), 0.95)"}

,

FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=

>}[Revenue])

Thanks

Satish

[sunny_talwar]

This

=Sum({<RecordID =

{"=Sum([Revenue]) >= Fractile(TOTAL Aggr(Sum([Revenue]), RecordID), 0.05) and Sum([Revenue]) <= Fractile(TOTAL Aggr(Sum([Revenue]), RecordID), 0.95)"},

FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=

>}[Revenue])

[satishkurra]

Hi Sunny

I have an issue here.

If i lasso on the bubbles, the chart is not displaying any value.

I think we are using TOTAL in fractile which is ignoring the dimension.

If i remove TOTAL the chart is going back to the initial state and no even distribution happens.

Could you please help me on the same?

Thanks

Satish

[satishkurra]

You can refer the same thread which has sample application

Fractile - QlikView

[Anil_Babu_Samineni]

What about this?

=Sum({<RecordID *=

{"=Sum([Revenue]) >= Fractile(TOTAL Aggr(Sum([Revenue]), RecordID), 0.05) and Sum([Revenue]) <= Fractile(TOTAL Aggr(Sum([Revenue]), RecordID), 0.95)"},

FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=

>}[Revenue])

[satishkurra]

Hi Anil

No luck.

Thanks

Satish

[sunny_talwar]

You might need to ignore selection in Fractile function

=Sum({<RecordID =

{"=Sum([Revenue]) >= Fractile({1} TOTAL Aggr(Sum({1} [Revenue]), RecordID), 0.05) and Sum([Revenue]) <= Fractile({1} TOTAL Aggr(Sum({1} [Revenue]), RecordID), 0.95)"},

FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=

>} [Revenue])

or may be ignore selection in specific fields you are selecting in.