topic Set Analysis trouble in QlikView

Set Analysis trouble

Anonymous — Mon, 22 Dec 2014 12:12:41 GMT

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.

Re: Set Analysis trouble

lironbaram — Mon, 22 Dec 2014 12:16:06 GMT

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

Re: Set Analysis trouble

Gysbert_Wassenaar — Mon, 22 Dec 2014 12:20:12 GMT

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?

Re: Set Analysis trouble

Anonymous — Mon, 22 Dec 2014 12:21:45 GMT

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

Re: Set Analysis trouble

lironbaram — Mon, 22 Dec 2014 12:22:26 GMT

updated the model have a look

Re: Set Analysis trouble

Anonymous — Mon, 22 Dec 2014 12:24:10 GMT

Hi Gysbert,

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

Thanks.

Re: Set Analysis trouble

lironbaram — Mon, 22 Dec 2014 12:28:10 GMT

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

Re: Set Analysis trouble

Gysbert_Wassenaar — Mon, 22 Dec 2014 12:31:50 GMT

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

Re: Set Analysis trouble

Anonymous — Mon, 22 Dec 2014 12:51:32 GMT

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.

Re: Set Analysis trouble

Gysbert_Wassenaar — Mon, 22 Dec 2014 12:55:07 GMT

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

Re: Set Analysis trouble

Anonymous — Mon, 22 Dec 2014 13:11:52 GMT

OK. Let's say I have a model with all my sales data. My app works in this analysis. After that I was told to add in my objects a reference number related to budget. Due to the model I have I can not link this budget table to the data model. From here I have 2 options:

1. Use set analysis to obtain it. The sample file attached shows it.

2. Calculate it in script and add a field somewhere in the model, avoiding isolated table in model.

Before doing option 2 I wanted to be sure about the first one.

Thanks for helping.

Marc.