Expression total of export Excel file not match with Qlikview expression total

[#1]

Hi Community,

I have export straight table data of qlikview application in excel file. but total of row of excel file not match with qlikview expression total on my local computer.

e.g.

a) My qlikview data                              b) My Excel data on local computer

Acct_no   Expression Total_EOP            Acct_no      Total_EOP  

1               10                                        1               10

2               20                                        2               20

3               30                                        3               30

4               40                                        4               40

5               50                                        5               50

----------------------------------                         ----------------------------------

Total          150                                       Total          100

I have give above data is sample data.

How i resolve this problem?

Thanks in advance.

[rajeshvaswani77]

Hi,

It is due to the dimension in your straight table.

Change your expression to

aggr(sum(Expression),Acct_no)

and it must work

thanks,

Rajesh Vaswani

[#3]

Hi Rajesh,

Thank you for your quik reply.

I have apply your logic in me expression but i didn't got correct data in excel file.when i export file from qlikview row total not match with excel file export from qlikview application.

I want some of row total in qlikview is same as in excel file wich is i have export on my local computer.

[PrashantSangle]

Hi,

Try like

Sum(aggr(sum(Distinct Expression),All Dimension of Table)

Regards

[rajeshvaswani77]

Hi,

Is the row total same when you visually see and total in table?

Without Export.

thanks,

Rajesh Vaswani

[#6 · Accepted solution]

Hi,

Thank you to every one for there reply.

I have export data of report with actual value it showing correct total in Excel file.Now total of row of Excel file match with Qlikview expression total.