Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Check now
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))
Check now
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))