QlikView12

[nerminemhadhbi]

I want to convert the total quantity into several units and the fields that I have to use it are in three tables. what solution do you propose knowing that I tried this code but it did not work

LET vconvert = '= Minstring';

Conversion_des_Unites:
CROSSTABLE (Conversion_des_Unites, Units) LOAD
Index,
Kg,
g,
q,
hg,
dag,
dg,
cg,
mg
RESIDENT Units;

Conversion_des_UnitesList:
LOAD convert as
RESIDENT Conversion_des_Unites
WHERE Conversion_des_Unites > 0;

DROP TABLE Conversion_des_Unites;