topic Re: Fractile Issue in QlikView

Fractile Issue

Mon, 17 Aug 2015 12:36:52 GMT

Hello All,

I am trying to create decile by using fractile.

With 1 fields it is working(APE).but with other it is not working(Rating).

What could be the issue.

I want the all the numbers from 1 to 10

Thanks

Priya

Re: Fractile Issue

swuehl — Mon, 17 Aug 2015 12:50:19 GMT

You can't have all decile numbers from 1 to 10 with only three distinct RATING values:

RATING

You need a broader distribution of RATING values to calculate full range of deciles.

Re: Fractile Issue

Mon, 17 Aug 2015 12:54:30 GMT

so how do we create decile .any other approach?

Re: Fractile Issue

swuehl — Mon, 17 Aug 2015 13:15:12 GMT

IMO, There is nothing wrong with the approach.

It's just that the distribution of RATING values can't really distinguish between an e.g. 30% or 40% quantile threshold, when there are few distinct values.

Let's a ssume RATING shows only a single value: 20

It does not really make sense to calculate a median, decile etc. if there is no variation in values.

3 distinct values are more than 1 distinct value of course, but still a decile calculation would give you a lot of valuable information.