Showing sum of values in table box

[#1]

Hi,

I have a table box with fields as 'Account no', 'Branch', 'Location', 'OredersReceived' with 'OrdersReceived' as measure.

In my fact table, I have more than one record for perticular account no of perticular brance and location.

So that many rows get listed in table box for each account number something like

A/C No     Branch     Location     OrdersReceived

1               ABC        LOC-1          1000

1               ABC        LOC-1           2000

2               PQR        LOC-2           2000

2               PQR         LOC-2          5000

Now my requirement is that instead of showing multiple rows for same account number, it should show single row for each account number and in 'OrdersReceived' column, sum of values for that account no should get displayed.

Something similar to below

A/C No     Branch     Location     OrdersReceived

1              ABC         LOC-1          3000

2              PQR         LOC-2          7000

Any ideas, how to achive it?

I tried using Chart, but it is summing all values of OrdersReceived i.e it is showing value 10000 for all records.

[Anonymous]

If you create a straight table (chart) with dimensions: A/C No, Branch and Location, and then an expression: Sum(OrdersReceived) you should get what you want.

[kaushiknsolanki]

Hi,

   Create a chart with dimension - account no,Branch and location.

   Then use the expression as sum(OrdersReceived).

   This will give you what you want.

Regards,

Kaushik Solanki

[#4]

Hi,

I tried to use Chart(Straight) table with sum(ordersreceived),but it is giving some weired sum amount, not the actual one and I am not able to trace why it is showing wrong summation.

Please help me out.

[kaushiknsolanki]

Hi,

   Can you upload the qvw file, with what ever you have done in it.

Regards,

Kaushik Solanki

[#6]

Hi Kaushik,

I am attaching qvw file created by me.

But I am having personal edition of qlikview, so I will not be able to open any external file.

Please help me.

Thanks in advance.

[kaushiknsolanki]

Hi,

  Your application doesnt have even a single record. Meaning there is no data in your application and thats the reason you are unable to see the output.

  Please make sure that you are fetching data from a proper datasource.

Regards,

Kaushik Solanki