topic Re: Fractile in a calculated field filtering issue in QlikView

Fractile in a calculated field filtering issue

mmg1984 — Sat, 16 Nov 2024 02:02:00 GMT

I'm trying to calculate the 5 percentile in a calculation as per below:

Fractile({<[Site]=>} Total
aggr(
(Max(DATA_VOLUME)/3600/1024+Max(DATA_VOLUME)/3600/1024*Forecast*IF([Host]='A',(1+Capped_Traffic),1))
/
(max(aggr(Sum(Bandwidth),[Site],[Sector]))*Efficiency*Utilisation)
,[Site])
, 0.05)

My issue is that it works as it should till I filter then it recalculates the percentile for the row that has been filter, I'm filtering by Site, any help will be more than welcome.

Re: Fractile in a calculated field filtering issue

Anil_Babu_Samineni — Wed, 06 Nov 2019 11:04:33 GMT

Perhaps this?

Fractile({<[Site]=>} Total
aggr(
(Max({<[Site]=>} DATA_VOLUME)/3600/1024+Max{<[Site]=>} DATA_VOLUME)/3600/1024*Forecast*IF([Host]='A',(1+Capped_Traffic),1))
/
(max({<[Site]=>} aggr(Sum({<[Site]=>} Bandwidth),[Site],[Sector]))*Efficiency*Utilisation)
,[Site])
, 0.05)

Re: Fractile in a calculated field filtering issue

mmg1984 — Wed, 06 Nov 2019 11:07:31 GMT

Hi,

I just fixed adding {<[Site]=>} after the aggr

Fractile({<[Site]=>} Total
aggr({<[Site]=>}
(Max(DATA_VOLUME)/3600/1024+Max(DATA_VOLUME)/3600/1024*Forecast*IF([Host]='A',(1+Capped_Traffic),1))
/
(max(aggr(Sum(Bandwidth),[Site],[Sector]))*Efficiency*Utilisation)
,[Site])
, 0.05)