topic Re: Partial Sum not correct in QlikView

Partial Sum not correct

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

Hello,

My partial sum is not correct. See screenshot below...

My issue is with the Duplicates column. If you add up 5+2+3 you get 10 but my partial sum says 13.

I have also attached my code. Any thoughts?

Re: Partial Sum not correct

vamsee — Tue, 18 Sep 2018 16:26:17 GMT

Hey Kayla, your attachment is missing. Can you please reattach your QVW

Re: Partial Sum not correct

kaylaramsey2 — Tue, 18 Sep 2018 16:40:02 GMT

I can only provide you with the expression code. I can not share client data.

Re: Partial Sum not correct

Frank_Hartmann — Tue, 18 Sep 2018 16:47:26 GMT

can u share a pic of the full expanded table?

Re: Partial Sum not correct

kaylaramsey2 — Tue, 18 Sep 2018 17:00:08 GMT

I am only looking at one patient here. The fully expanded view would just show you the one patientID for each LabNM. The Result column is just a count of a specific flag. The partial sum the Result column shows is the correct number. My issue is with the Duplicates partial sum

Re: Partial Sum not correct

Frank_Hartmann — Tue, 18 Sep 2018 18:32:21 GMT

can you scramble the sensitive data and upload the qvw?

for scrambling go to settings --> document settings --> scrambling and choose the fields with sensitive data to

scramble. then save the document and upload the qvw!

Re: Partial Sum not correct

pooja_prabhu_n — Thu, 20 Sep 2018 06:41:33 GMT

Hi,

Partial Sum is considering expression total.

hence Duplicate=Total Result-1

=14-1

=13

You are getting 13 as Duplicate partial sum.

If you are using Straight table you can change the expression total to sum of Rows.

In pivot table you can use below expression.

=Sum( Aggr( Sum(Result)-1,LabNM))

Please find the attached qvw file for your reference

Thanks,

Pooja