- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlik sense
venue1:
load *,
If(Match("Measure Name",'Revenue'),Sum(Value))
Resident tab1;
is this correct
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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";
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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