Qlik Sense App Development

New Contributor

Fractile & Qlik Sense Drill Down.

Hi,

I am trying to get 95th, 75th and 55th percentiles using fractile function in a drill down in qliksense. The drill down is like below,

Country>State>County>City>Zip.

I need to achieve the following,

1. Get the fractile values to show one level up from State>County>City>Zip, i.e at country level fractile values should show at country level and

> when drilled down to state it should show the fractile values that of Country

> when drilled down to County it should show the fractile values that of  State

> when drilled down to City it should show the fractile values that of County

> when drilled down to Zip it should show the fractile values that of  City.

The set of values I am trying to do the fractile are resultant of the expression Num/Denum which are in %. and I stored them in a variable called Var1%. I have written the below code in the chart

If

(

GetSelectedCount(Country)>=0 and GetSelectedCount(State)=0

,Fractile ({1<Country =>}total aggr(\$(Var1%),Country),0.9)

, If

(

GetSelectedCount(State)>=1 and GetSelectedCount(County) = 0

, Fractile ({1<Country =>}total aggr(\$(Var1%),Country),0.9)

, If

(

GetSelectedCount(County)>=1 and GetSelectedCount(City) =0

, Fractile ({1<State = >}total aggr(\$(Var1%),State),0.9)

, If

(

GetSelectedCount(City)>=1 and GetSelectedCount(Zip)= 0

,  Fractile ({1<County = >}total aggr(\$(Var1%),County),0.9)

, If

(

GetSelectedCount(Zip)>=1

,   Fractile ({1<City = >}total aggr(\$(Var1%),City),0.9)

)

)

)

)

)

But doesn't work properly. when drilled down it gives same percentage to all 95th, 75th, 55th fractile values.