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.
Could any one please help me with this.
Thank you in Advance,
PKV
swuehl
