
Re: Matrix Algebra
Klaus Kring Jan 18, 2013 7:21 AM (in response to jamesward)Hi James,
you could get specific 'fields' with a sorted table and peek to defined rows.
What is the formula besides the syntax of Excel or QlikView?
Ciao
Klaus

Re: Matrix Algebra
Antoine Frangieh Oct 14, 2013 6:14 AM (in response to jamesward)I am afraid not.
I think the best way is to transform your scalar operation into a simple linear operation.
In QV, you have a Crosstable interpretation, transform your matrix into the following:
AA, AB, AC, BA, BB, BC, CA, CB, CC
1, 3, 2, 2, 1, 2, 5, 1, 0A,B,C
2, 0, 0
Resultante:
AA*A, AB*B, AC*C BA*A, BB*B, BC*C, CA*A, CB*B, CC*C (edited: corrected the appropriate vector index)
You will have to code...
Hope this helps
(and let me know if you found a faster way )
Cheers,
Antoine 
Re: Matrix Algebra
Sajeevan Govindan Oct 14, 2013 6:49 AM (in response to jamesward)Does the below help you?
Data1:
LOAD * INLINE [
A, B, C
1, 3, 2
2, 1, 2
5, 1, 0
];Data2:
Load * INLINE [
pA, pB, pC
2, 0, 0
];let nRows1 = NoOfRows('Data1')1;
let nRows2 = NoOfRows('Data2')1;for i = 0 to nRows1
let vA = peek('A',$(i),'Data1');
let vB = peek('B',$(i),'Data1');
let vC = peek('C',$(i),'Data1');
for j = 0 to nRows2
let vpA = peek('pA',$(j),'Data2');
let vpB = peek('pB',$(j),'Data2');
let vpC = peek('pB',$(j),'Data2');Data3:
load
($(vA) * $(vpA)) + ($(vB) * $(vpB)) + ($(vC) * $(vpC)) as xA
AutoGenerate(1);next j;
next i;
Re: Matrix Algebra
Roy Alcalde May 12, 2014 1:20 PM (in response to Sajeevan Govindan )I had a similar requirement as with original poster. The post by sajeevan helped.
