Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

helen_pip
Contributor II

Current Month - Fractile Function

    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

2 Replies
Not applicable

Re: Current Month - Fractile Function

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

vinay_bangari
Valued Contributor III

Re: Current Month - Fractile Function

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

Community Browser