Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
marcarreras
Specialist
Specialist

Set Analysis trouble

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.

2014-12-22 13_01_19.jpg

10 Replies
lironbaram
Partner
Partner

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?


talk is cheap, supply exceeds demand
marcarreras
Specialist
Specialist
Author

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

lironbaram
Partner
Partner

updated the model have a look

marcarreras
Specialist
Specialist
Author

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
Partner
Partner

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?


talk is cheap, supply exceeds demand
marcarreras
Specialist
Specialist
Author

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.


talk is cheap, supply exceeds demand