Discussion Board for collaboration on QlikView Scripting.
I want to join two tables, and insert the new calculate data on the first one, look at the example:
I would like to include on the Table 1, this lines that means (Dollar: Value * Rate on the same Date)
I'm try to do like this, but I continue have a problem:
'LocalValue' as [Measure],
[Value]*[Rate] AS [Value]
WHERE [Measure] = 'Dollar'
but I'm geting this error message:
What I'm doing wrong?
Load * inline
Not quite clear on the difference in line 1 and 2 resp. 3 and 4 in the first table. Please explain.
If there is a 1:1 ratio, would recomment to use a mapping:
mapRate: MAPPING LOAD Date, Rate FROM ....
Value * APPLYMAP('mapRate', Date) AS Local
If there are multiple currencies involved, you may consider a combined key.
Else check on the INTERVALMATCH-function
'Dollar' as [Measure],
Value * Rate as [Total Value]
DROP Tables Table1, Table2;
Attaching the sample application for ease of understanding.
Load * inline [
left join (Table2) load
'LocalValue' as Measure,
Where Measure = 'Dollar';
load Measure, Value*Rate as Value, Date
DROP Table Table2;