Strange Problem

[ttal7878]

Hi,

I have a strange problem,

When I try to make a sum of the sale_Amount$ column, for no apparent reason the result doubles itself.

It's problematic for me to upload my real model,

and I can't imitate the problem in an example model, So I'll try to explain with picture from my model.

I have a fact table that displays the following data

You can see in the picture that the total Sale Amount$ for the Unique_num is:24$

But, if I do the following calculation:

=sum({<Action=,SaleDateKey={">=$((VMinDate))<=$((VMaxDate))"}>}Sale_Amount$)

I get the result 327$

You can see in the picture that for 'Action' = 'collection', the Sale_Amount$ has doubled.

Can anyone explain, what I'm doing wrong?

[ttal7878]

I have loaded only the fact table,and I get the correct result,

it is possible that the relationships with one of the dimensional tables will create the problem?

[srchagas]

Hi yes... Could be

If some one dimension have the same key 2 times for example i will be duplicate the record.

try use one  distinct in load of dimensions. one by one in dimensions, u probably will find the dimension with the duplicate record.

or load the dimensions in another Qlikview App, user RowNum() in begin of load  and a listbox select the option "Shw Frequence" , one probably will have the number "2"