Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

abc_18
Contributor

Running total Value

Hi,

I am using three expression and drill down option for (month and date) in bar chart.

1> Tickets Created=Count(DISTINCT{<Flag={'[Date Submitted]'}>} IncidentNumber)

2>Tickets Closed=Count(DISTINCT{<Flag={'[Date Closed]'},Status={'Closed'}>}IncidentNumber)

and in third expression I am calculating difference between these two ie'

3>Baclokg Tickets=Count(DISTINCT{<Flag={'[Date Submitted]'}>}IncidentNumber)

-

Count(DISTINCT{<Flag={'[Date Closed]'},Status={'Closed'}>}IncidentNumber)

but in Third expression I want to calculate running total value for backlog tickets (Month/Date wise), so if I click on bar chart for Feb-15(Monthly), it should display 198 for 28-02-15.

calculation is like this:- (968-870=98+190=198).but currently I am getting only difference between these two ie' 98

Month Wise.pngDateWise.png

1 Reply
MVP & Luminary
MVP & Luminary

Re: Running total Value

Try this one:

Sum(

     Aggr(

          RangeSum(

               Above(

                    Count(DISTINCT{<Month=,Flag={'[Date Submitted]'}>}IncidentNumber)

                    -

                    Count(DISTINCT{<Month=,Flag={'[Date Closed]'},Status={'Closed'}>}IncidentNumber)

               ,0, RowNo())

          )

     ,Month

)


talk is cheap, supply exceeds demand