Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Wrong Total value in pivot table

Dear Experts ,

I am Designing Reports in both Reporting tool and Qlikview .  i got exact output as per my requirement in reporting tool but in qlikview i am facing issues on displaying partial total and overall total .

i want to display partial total in pivot chart , where in expression i used FABS function to convert negative value in to positive .

Please suggest how to display correct total value and in overall total expression i am getting group name wise total , i want to display overall total to find out percentage .

Please check my attached image and suggest . i want to display output in BI as per attached screen shot  (1)

1 Solution

Accepted Solutions
Highlighted

Check now

Capture.PNG

Exp for Amount

=Sum(Aggr(fabs(sum({<DOCUMENT_TYPE = {'RPT'}>}LOCAL_AMOUNT)), Group, GLAccountName))

Exp for Overall Total

=Sum(TOTAL Aggr(fabs(sum({<DOCUMENT_TYPE = {'RPT'}>}LOCAL_AMOUNT)), Group, GLAccountName))

View solution in original post

1 Reply
Highlighted

Check now

Capture.PNG

Exp for Amount

=Sum(Aggr(fabs(sum({<DOCUMENT_TYPE = {'RPT'}>}LOCAL_AMOUNT)), Group, GLAccountName))

Exp for Overall Total

=Sum(TOTAL Aggr(fabs(sum({<DOCUMENT_TYPE = {'RPT'}>}LOCAL_AMOUNT)), Group, GLAccountName))

View solution in original post