topic Re: Total in QlikView

Total

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

HI All,

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 ..

Anil_Babu_Samineni — Tue, 17 Oct 2017 07:23:53 GMT

You loaded one table only, And you said - 2 tables data are coming.

smilingjohn — Tue, 17 Oct 2017 07:30:28 GMT

Hi Anil,

I mean The Charts ..

Table A and Table B

Anil_Babu_Samineni — Tue, 17 Oct 2017 07:33:30 GMT

Looks like, You are getting "Running Total". May be some times, They don't have data.. Can you scroll down and test which line doesn't have points

prma7799 — Tue, 17 Oct 2017 07:35:25 GMT

Please check this...

smilingjohn — Tue, 17 Oct 2017 07:53:12 GMT

Hi PM.

Thanks for the reply ..