Compare 2 fields from 2 tables - With Set Analysis

matancha — Sun, 24 Jul 2011 11:42:46 GMT

Hello All.

Please see the file attached, and look on it's script.

In this file I have 3 tables:

SerialCakes: The serial number for each cake, and it's request quantity.

RecipeIngredients: Cake ingredient + coefficient(quant for 1 cake).

Transorder: list of the De-facto consumption.

In the GUI I created 2 straight tables: "Recipe Ingredients", "De Facto".

What I want to show is a straight tables that compare the values from "Recipe Ingredients" and "De Facto".

For expl:

If I select "Sponge cake", I want to show a compare straight table like this:

How can I do that (without changing the tables links, all the tables link with serial.serial)?

Hope that is clear, and tks for your ideas...

Matan.

topic Compare 2 fields from 2 tables - With Set Analysis in QlikView