Problem regarding Total in Pivot Table

sarfaraz_sheikh — Tue, 31 Mar 2015 09:42:59 GMT

Dear All,

I am using below code however i am not getting the proper total .I am using Pivot table

Kindly suggest what should i have to do for getting right total . Snapshot and QVW file is also attached here for your refernce.

Load * inline

[D_NO,Remarks,id
1, Excellent,02
1, Faboulous,01
2, Very_good,03
2, Faboulous,01
3, Good,04
3, Faboulous,01
4, Average
4, Performance
5, Poor,05
5, Performance
];

EMPP:
LOAD FIRST_NAME,
     LAST_NAME,
     SSN,
     BIRTH_DATE,
     ADDRS,
     SEX,
     SALARY,
     SUPERSSN,
     D_NO,
     START_DATE
FROM
C:\Users\Sarfaraz.Sheikh\Desktop\QVD_Files\EMPP.QVD
(qvd);

Exit script;

Sarfaraz

Re: Problem regarding Total in Pivot Table

sarfaraz_sheikh — Tue, 31 Mar 2015 09:45:16 GMT

Dear All,

Please find the attached QVW file .

Sarfaraz

topic Problem regarding Total in Pivot Table in QlikView

Problem regarding Total in Pivot Table

Re: Problem regarding Total in Pivot Table