topic Re: Calculated Fractile in QlikView

Calculated Fractile

Anonymous — Mon, 12 Sep 2016 15:40:58 GMT

Hi,

I have a good working Fractile Reference Line in a scatter chart:

=Fractile(Aggr(COUNT(DISTINCT{$<ivStat={1}>} Account#),StaffName),0.95)

However, when I select/filter by staff name, the reference line moves.

What I would like to happen is that the reference line stays and a pointer to the staffname to appear. So I could see the staffname performance in reference to the 95% fractile..

Thanks

Re: Calculated Fractile

Anil_Babu_Samineni — Tue, 13 Sep 2016 08:25:39 GMT

Perhaps This

=Aggr(Fractile(COUNT({$<ivStat={'1'}>} DISTINCT Account#),StaffName),0.95)

Re: Calculated Fractile

Anonymous — Tue, 13 Sep 2016 12:33:45 GMT

Hi Anil,

Thanks for your response:

The Fractile() function needs the 0.95 parameter. However, I did switch positions, including the parameter, but it did not work.

Re: Calculated Fractile

sunny_talwar — Tue, 13 Sep 2016 12:52:25 GMT

So you are looking for a way to ignore selection in staffname field?

=Fractile({<StaffName>}Aggr(COUNT(DISTINCT{$<ivStat={1}, StaffName>} Account#),StaffName),0.95)

Re: Calculated Fractile

Anonymous — Tue, 13 Sep 2016 13:11:36 GMT

That's right Sunny.

Your suggestion makes sense, but its not working.

Thanks

Re: Calculated Fractile

jonathandienst — Tue, 13 Sep 2016 13:14:25 GMT

I agree with Sunny - you need to override the relevant fields in Fractile() to prevent the Aggr() being reduced by that selection. That is what is happening at the moment and is why your reference line is changing. It also needs to be overridden inside the Aggr().

If necessary, change the field name (StaffName) to the correct name (or names) from your application.

Re: Calculated Fractile

Anonymous — Tue, 13 Sep 2016 13:53:37 GMT

Sunny ( and J.D.) , thanks very much - you were correct. I had to apply this methodology also to my dimensions/expressions.

Thanks!!