number

[smilingjohn]

I have chart A and chart B ...

IN chart a i have clicked on any of the number then it will show me all the months  and makes other zero  and displays the numbers for that row only

as shown in the chart 1 ..

now i want to replresent this like chart B ..

but here the values are shwing in negative becuase i have taken out PDPeriodMonth from expression..

how do i achieve the chart B with same values and there should not be any negative values.....

Please find the attachment of the QVW file

Thanks in advance

[sunny_talwar]

You have used this for OPEN

RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo()))

and you are saying you don't want to use this?

RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo())) * Avg (1)

The output you want is (when Sept 2016 is selected) only one row with 28 for open and you don't want to see all the other rows? Is that correct? Why do you not want to multiply by Avg(1)? What is the problem there?

[smilingjohn]

Hi Sunny ,

If i do so then i will not see the runing total (OPEN)

for example if you clear everything ,,And look at Feb-2016 the created is 0 and CLosed is also 0

but the Open is 20.. and this is how i want ..

Now if i will use *(avg) 1 then this will not show me the Oepn count when created and Closed are 0 ..

Thats the reason i prefer using this expression

RangeSum(Above(Sum({<PDReportPeriodB>}PDRunningOpenCount), 0, RowNo()))

[sunny_talwar · Accepted solution]

Then it seems to be a problem of missing data and you need to look at this

Generating Missing Data In QlikView