Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
marcarreras
Valued Contributor

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

Re: Set Analysis trouble

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

MVP & Luminary
MVP & Luminary

Re: Set Analysis trouble

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
Valued Contributor

Re: Set Analysis trouble

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

Partner
Partner

Re: Set Analysis trouble

updated the model have a look

marcarreras
Valued Contributor

Re: Set Analysis trouble

Hi Gysbert,

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

Thanks.

Partner
Partner

Re: Set Analysis trouble

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

MVP & Luminary
MVP & Luminary

Re: Set Analysis trouble

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


talk is cheap, supply exceeds demand
marcarreras
Valued Contributor

Re: Set Analysis trouble

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.

MVP & Luminary
MVP & Luminary

Re: Set Analysis trouble

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


talk is cheap, supply exceeds demand