Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Does anyone know if we can call upon C language within Qlikview?
Thanks,
Antoine
I don't think so. But what do you want to achieve? Probably there is a "QlikView way" to do this.
A table with its fields might not be so much different.
Thanks Stefan.
My intent is to work with vectors within QV. (Assuming that k is 0 to simplify)
I have started by declaring the function Magnitude
SET f.v.Magnitude=
if(
len($1)>0 and len($2)>0
,sqrt(sqr($1)+sqr($2))
,'Rejected'
)
;
Then the function Angle
SET f.v.Angle=
if(
len($1)>0 and len($2)>0 and $1<>0
,atan($2/$1)
,'Rejected'
)
;
then I load the i, j, k magnitudes:
[0]:
LOAD *,
$(f.v.Magnitude(i, j)) as Magnitude
;
LOAD i,
j,
k,
$(f.v.Angle(i, j)) as Angle
FROM
[vector representation v1 - coordinates.xlsx]
(ooxml, embedded labels, table is Sheet1);
Note that for an obscure reason, the same script won't work if I load it like this:
[0]:
LOAD *,
$(f.v.Magnitude(i, j)) as Magnitude,
$(f.v.Angle(i, j)) as Angle
;
LOAD
i,
j,
k
FROM
[vector representation v1 - coordinates.xlsx]
(ooxml, embedded labels, table is Sheet1);
Thanks,
Antoine
I am not sure if I understood your issue. But your both sections of code works fine with my inline data. PFA
Thanks, now it works. must have written something wrong in my initial attempt. weird.