topic Re: Current Month - Fractile Function in QlikView

Current Month - Fractile Function

helen_pip — Fri, 21 Sep 2012 12:11:55 GMT

Hello,

I have the following expression in a straight table and the expression is O.K

Fractile

({<[Reportable Month]={$(=monthstart(today()))

} >}

[Total Wait]

,0.95)/1440

I also have in my label for this expression:

monthstart(today

())

However when I apply this expression, I return no data

I am trying to estbalish the current months 95th centile and display the value in a table.

Could anyone advise whether such a expression can be used in a gauge graph?

Kind Regards

Helen

Fri, 21 Sep 2012 13:53:54 GMT

Dear Helen,

In my oppinion you need to aggrigate this exprression over the Month.

Try Like:

Fractile (aggr(Sum({<[Reportable Month]={$(=monthstart(today())} >}[Total Wait]),[Reportable Month]),0.95)/1440

Regards

Rahul

Anonymous — Fri, 21 Sep 2012 17:38:05 GMT

Hi Helen can you post a sample application with some sample data so that we can help with.