Discussion board where members can get started with QlikView.
I have two sets of data
Set A has the following (this is SQL pulling from database)
Company (primary key)
Sales Order Number
Set B has the following (this is excel file manually managed by me)
Share (% in each industry segment)
I want to join the two sets by loading them in QV so the Share in each Industry Segment applies to the Revenue.
For example, ABC Company has following industry segmentation
So if it has a Revenue of $1M, it should show up as
I tried to create a new expression (Adjusted Revenue) with = Share * Revenue but it gives erroneous data. Please help.
For joining purposes just use the join statement like bellow:
// This does the join, based on the common fields, in this case the "Company" field.
From [Excel file];
// Loads all the fields from the previously created table SetA with the Revenue and Share
// Since both fields are in the same table, you can do the calculations now
Share * NumberRevenue as [Adjusted Revenue]
drop table SetA;
Thanks. It worked. The error was because the formula required me to put the sum function and include the share in the parenthesis.
If your issues is resolved can you please close the thread marking correct/helpful responses accordingly.