topic Re: Passing data between two tables (after calculation) in QlikView

Passing data between two tables (after calculation)

Wed, 07 Dec 2011 10:13:34 GMT

Hi,

I'm looking for a way to pass data into a new table/chart based on an on-the fly calculation in another table.

Assuming I have a fruit basket:

FRUITS:

Apple

Banana

Pear

Orange

Kiwi

Plum

* CATEGORY OF FRUITS:

Cat 1

Cat 2

Cat 3

Cat 4

Cat 1

* I will assign a category calculated in an expression to all of them.

This is for example based on price clusters:

if the price is below 1 USD/per piece, then assign to Cat 1 and so on in pre-set clusters.

Now, I would like to count and group the CATEGORY OF FRUITS to show the count in the clusters:

CATEGORY OF FRUITS:

Cat 1

Cat 2

Cat 3

Cat 4

Count of FRUITS:

My issue is that when inserting the calculation from the expression (in the first table) as dimension (in the second table), I get an error message since it doesn't know the source (which fruit categories exist based on FRUITS) of the calculation.

The target solution should show the grouping and the count of the fruits in the defined cluster.

Is there:

A) a way to pass the data in the first table to the second

B) anyother meaningful way to solve the issue

PS: It is important to keep the functionality to have the calculation of the clusters in the presented way and be done on-the-fly.

Thanks.

Gerard

Re: Passing data between two tables (after calculation)

IAMDV — Wed, 07 Dec 2011 12:55:40 GMT

Hi Gerard,

Is there:

A) a way to pass the data in the first table to the second

Answering this question, have you explored using Indirect Analysis? I had similar requirement in the past and I have got it working using Indirect Analysis. I am attaching a Set Analysis tutorial which contains Indirect Analysis. Using this approach you can pass the data from Table1 to Table2 on the fly and also considering the selections in Table1 (If any).

I hope this helps!

Cheers - DV

Re: Passing data between two tables (after calculation)

Fri, 09 Dec 2011 09:28:56 GMT

Hi DV,

Thanks for your answer.

I have tried your way without success so far.

Included a QV where I show the base table, the intented outcome.

Based on your comment, one should be able to "read" into the initial table and group and count.

In my scenario, I can not use the direct way (as shown in intented outcome).

Any ideas how I can tackle this issue.

Thanks

Gerard