topic Problem in sum the column name in QlikView

Problem in sum the column name

Tue, 23 Aug 2011 08:58:56 GMT

Hello Guru's

There is a column name Peices it contains how many pieces are having for a particular shipment. In the souce when I am checking the a particular invoice it contains 41 but as the same when I am checking in QV it shows 82 pieces. (Invoice-------> Shipments -------> Pieces)

I wrote a function like Sum(Pieces), Count of Pieces and I tried Distinct alos it shows the same 82 Pieces.

How it's possible in the orginal data is having only 41 but in QV it shows 82 Pieces.

Anybody has faced such problem like this ..

Regards

Joe

Re: Problem in sum the column name

sridhar240784 — Tue, 23 Aug 2011 09:42:31 GMT

Hi Joe,

Do you have only one table where you get the shipment, invoice and pieces in it or you are trying to join more than one table to get these information.

if you are more that one table joining to arrive at this info then you need to look at you joins. improper joining of tables may cause this kind of issues.

- Sridhar

Problem in sum the column name

Tue, 23 Aug 2011 10:05:19 GMT

Hello Sridhar,

Thanks for your reply, as advised by you I have checked, Invoice, pieces, shipment are all in one table (Fact table).

Even I am getting a count(shipment) is also correct(41), its something strange how to handle this...

Thanks a lot

Joe

Re: Problem in sum the column name

sridhar240784 — Tue, 23 Aug 2011 10:29:02 GMT

Hi,

Not sure why this happening and its is very hard to suggest you also without more information.

Could you please post your data model here (i.e) Table viewer image

- Sridhar

Problem in sum the column name

Wed, 24 Aug 2011 06:24:56 GMT

Dear Sridhar,

Sorry for the delay, when I was trying to upload the relational diagram its shows a error of try again later.

I don't think there is a problem in the realations because I tried several invoices its perfectly as what it is.

Only problem for one invoice the piece is doubled its really peculiar to me.

I don't know how to dig and find a solution.

Regards

Joe