topic Re: Total value in QlikView

Total value

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI Expertise

Need Help

Please find the attached QVW file..

I have two charts Table A and Table B

Table A works fine with runing total with one dimension which is years and month .

it doesnt work with running total when i add PDSeverity into it.

Please provide some suggestions

If you look at the Table A the It is making the Runing Total ..

When u had PDSeverity into it ..It doesnot perform the Runing total..

Iam looking to get the runing total even if i add PD Severity also ..

If you look in the Tabke A ...for Dec-2015 , Open=9206 and Closed=0

Open-Close= 9206 and this value will be added to Open again and will be subtracted by Close and similarly it follows .

which is working fine when i dont add PDSeverity.

it doesnot work when i add PdSeverity.

It should work even if i add PD Severity ......

...

Tahnks in Advance ..

Re: Total value

sunny_talwar — Tue, 17 Oct 2017 15:33:08 GMT

May be try this for Running Total expression in thTable B

RangeSum(Above(Sum(PDRunningOpenCount), 0, RowNo()))

Re: Total value

smilingjohn — Tue, 17 Oct 2017 15:51:11 GMT

HI Sunny

Thanks for the reply ..

Sunny this is not working properly , I mean its not giving accurate result..

When i click on the MOnth Year any one of it.. the values are changing..

Re: Total value

sunny_talwar — Tue, 17 Oct 2017 15:53:29 GMT

Was this working in Table A with selection

Try this

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

Re: Total value

smilingjohn — Tue, 17 Oct 2017 15:56:12 GMT

Sunny ,

And also i have to include the maximu PdLoadDate for the expression you provided..is this correct way of writing this ?

RangeSum(Above(Sum(<PDLoadDate={"$(=Date(Max({1}PDLoadDate), 'DD-MM-YYYY'))"PDRunningOpenCount), 0, RowNo()))

Re: Total value

sunny_talwar — Tue, 17 Oct 2017 16:08:10 GMT

My bad, try this

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

Re: Total value

sunny_talwar — Tue, 17 Oct 2017 16:09:20 GMT

May be this

RangeSum(Above(Sum({<PDLoadDate = {"$(=Date(Max({1}PDLoadDate), 'DD-MM-YYYY'))"}>} PDRunningOpenCount), 0, RowNo()))

Re: Total value

smilingjohn — Tue, 17 Oct 2017 16:14:19 GMT

Thanks a lot sunny....

You are the one who really helps everytime during most diffuclt times..Thanks again...

Sunny your expression is working

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

Can you please take a moment to explain me how it works ?

Re: Total value

sunny_talwar — Tue, 17 Oct 2017 16:17:17 GMT

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

Accumulating and ignoring selection in PDReportPeriodB... so regardless of what you select in PDReportPeriodB your chart will show everything

2) Avg(TOTAL 1)

Since we ignored selection in PDReportPeriodB and somehow need to remove the rows which are not selected, we use this expression which will equal to 1 for selections and 0 for out of selection rows.

Re: Total value

smilingjohn — Tue, 17 Oct 2017 16:26:08 GMT

You are just great