topic Re: Pivot Table showing Wrong Total in QlikView

Pivot Table showing Wrong Total

sarfaraz_sheikh — Tue, 31 Mar 2015 11:23:10 GMT

Dear All,

Why My Pivot table is showing wrong total.....please check suggest me where i am doing wrong....

My QVW and Snapshot is attached here.

Sarfaraz

sarfaraz_sheikh — Tue, 31 Mar 2015 11:24:21 GMT

Dear all,

Below is the snapshot for the same...

sarfaraz

rubenmarin — Tue, 31 Mar 2015 11:25:32 GMT

Hi Sarfaraz, that document doesn't have any chart, seems you uploaded before saving or uploaded another document.

MK_QSL — Tue, 31 Mar 2015 11:27:47 GMT

Ruben.... No data also...

rubenmarin — Tue, 31 Mar 2015 11:31:06 GMT

Right.

Anyway I think Sarfaraz is looking for an expression in second table like:

Sum({<D_NO={"*"} SALARY)

Sum({<D_NO*={"*"} SALARY)

Aggr(Sum(SALARY), D_NO)

Well it seems not, problem was the first table.

sarfaraz_sheikh — Tue, 31 Mar 2015 11:32:13 GMT

Please find the attached QVW .

Sarfaraz

MK_QSL — Tue, 31 Mar 2015 11:35:07 GMT

Hi Sarfaraz,

What should be the Total Salary as per your requirement ?

rubenmarin — Tue, 31 Mar 2015 11:36:02 GMT

Hi, maybe:

=Sum(Aggr(Sum(SALARY), Remarks))

BTW, I think your original values were correct, as this is duplicating salaries located in more than one Remark

sarfaraz_sheikh — Tue, 31 Mar 2015 11:46:01 GMT

Hi Manish,

The total salary should be sum of all rows in both the table...However one table showing correct total and onother one is showing wrong total .

sarfaraz

sarfaraz_sheikh — Tue, 31 Mar 2015 11:46:51 GMT

Hi Ruben,

Your solution is working as expected ....Thanks a lot for help !!!!!!

Sarfaraz