topic Re: Total for calculated dimension is showing wrong in QlikView

Total for calculated dimension is showing wrong

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

‌

Hi ,

I have calculated dimension in one pivot table.

The definition of the calculated dimension is as follow:

aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB)

Now I want to print the total of this with its label.

Now for total I am using following code total:

Sum(aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))

My problem is the result of the total is not matching with the dimension value. Please see the attached screen shot.

Please advise what wrong I am doing here.

Anil_Babu_Samineni — Tue, 05 Dec 2017 15:28:17 GMT

Expression seems okay, Can you show the Total as well?

its_anandrjs — Tue, 05 Dec 2017 15:30:42 GMT

Try one of this from chart properties of the pivot chart.

Sum of rows

Expression total

And check which matches your result.

ashis — Tue, 05 Dec 2017 15:35:50 GMT

‌Thank thank Anil for your reply for total I m using

Sum(aggr(sum({<xxx=,Date={"$(vVariable)"}>}YYYY),AAA,BBB))

Anil_Babu_Samineni — Tue, 05 Dec 2017 15:37:26 GMT

I believe same as before, Seems correct to me. What values are you facing wrong?

ashis — Tue, 05 Dec 2017 15:37:31 GMT

‌thank you Anand for your reply . It didn't work though.

ashis — Tue, 05 Dec 2017 15:38:51 GMT

‌if you see the attached image the sum should result 4 however I am h.getting 6

Anil_Babu_Samineni — Tue, 05 Dec 2017 15:40:28 GMT

I can understand your issue, Can you attach application to investigate where values are getting ??

ashis — Tue, 05 Dec 2017 15:50:57 GMT

‌due to security issues unable to upload app.