topic Re: Fractile QlikView in QlikView

Fractile QlikView

satishkurra — Fri, 18 May 2018 16:43:39 GMT

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

Re: Fractile QlikView

sunny_talwar — Fri, 18 May 2018 16:48:53 GMT

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])

Re: Fractile QlikView

satishkurra — Fri, 25 May 2018 23:55:42 GMT

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

Re: Fractile QlikView

satishkurra — Sat, 26 May 2018 00:00:40 GMT

You can refer the same thread which has sample application

Fractile - QlikView

Re: Fractile QlikView

Anil_Babu_Samineni — Sat, 26 May 2018 05:06:37 GMT

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])

Re: Fractile QlikView

satishkurra — Sat, 26 May 2018 12:52:05 GMT

Hi Anil

No luck.

Thanks

Satish

Re: Fractile QlikView

sunny_talwar — Sun, 27 May 2018 00:28:13 GMT

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.