Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
matancha
Contributor

Compare 2 fields from 2 tables - With Set Analysis

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:

PartNamePartDes

Recipe
De FactoGap (Resipe - De Facto)
1008flour2492490
1009Sugar373.80373.8
1015eggs18003481452
1020rum60060
1033Wine0248-248


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.

Community Browser