Qlik sense

[prat121]

venue1:
load *,
If(Match("Measure Name",'Revenue'),Sum(Value))
Resident tab1;

is this correct

[prat121]

tab1:
LOAD
"Sr. No",
"Business Unit",
Division,
Plant,
"Material Group",
Product2,
Vendor_Customer,
"Purchasing Organization",
Bucket,
"Date",
"Measure Name",
Value,
Goal
FROM [lib://source/Financial_Analysis/Financial Analysis.xlsx]
(ooxml, embedded labels, table is [Finance Data]);

this is the table from excel I have imported into Qlik sense, 

venue1:
load *,
If(Match("Measure Name",'Revenue'),
Sum(Value))
Resident tab1;
i am trying to load a table where in if the measure name is revenue i want the sum(value) so what way should i write the measure as

[anat]

tab1:
LOAD
"Sr. No",
"Business Unit",
Division,
Plant,
"Material Group",
Product2,
Vendor_Customer,
"Purchasing Organization",
Bucket,
"Date",
"Measure Name",
Value,
Goal
FROM [lib://source/Financial_Analysis/Financial Analysis.xlsx]
(ooxml, embedded labels, table is [Finance Data]);

venue1:
load "Measure Name" // here use key field
If("Measure Name"='Revenue',Sum(Value))
Resident tab1

group by "Measure Name";

[rwunderlich]

Do you want the Sum(Value) for the entire table? Or a total for each business unit? Or are you trying to create a new field in the table named "Total Revenue"?

-Rob

[prat121]

I want to create a new table which has various different measures and in that table i would like the sum(values) of those various measures which are present in the measure table.

[prat121]

sorry for my words if they are not clear, You are correct I would like to create a new table that includes different measures or you can consider business units and these are present in the field name "Measure Name"

[rwunderlich]

Should all the Measures use "Sum(Value)"? Or do some use a different expression?

If they are all "Sum(Value)" then you can use:

venue1:
load "Measure Name" 
Sum(Value) as MeasureValue
Resident tab1
group by "Measure Name";

-Rob