Set Analysis trouble

[Anonymous]

Hi all,

I made a qvw with sample data in order to show you the problem I have. I have to obtain the sales value in a table chart based on a dimension isolated from the facts table. It is the orange object.

Could anyone help me with the expressions, please? I appreciate any help.

Thanks.

[lironbaram]

hi

have a look at the attach example

i also made changes to the script

so in namename field each name is loaded once

now it works

[Gysbert_Wassenaar]

Since your two tables are not associated you will be calculating with a cartesian product in any expression that uses fields from both tables. You won't get any sensible results. What is the result you are expecting?

[Anonymous]

Liron, it doesn't work. Total sales is 6.399, not 21.022.

[lironbaram]

updated the model have a look

[Anonymous]

Hi Gysbert,

The expected result is like the second object at left, named "Sales from Facts". Any idea about how to get it?

Thanks.

[lironbaram]

hi

as i wrote above ,

i changed the load script

so you load only distinct values to the namename field

and now it works ok

have a look

[Gysbert_Wassenaar]

Well, you already have that object so what's the problem?

[Anonymous]

In my complete model I can not link these tables, and I can not make this field Distinct. I need to obtain the value using the dimension in the other table (which has the same possible values).

If it is not possible, I will try another way. Just tell me.

Thanks.

[Gysbert_Wassenaar]

I still don't understand what you're trying to calculate.