Running total Value

abc_18 — Wed, 03 Feb 2016 10:29:47 GMT

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

Re: Running total Value

Gysbert_Wassenaar — Wed, 03 Feb 2016 19:01:33 GMT

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

)

topic Re: Running total Value in QlikView

Running total Value

Re: Running total Value