Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nerminemhadhbi
Contributor
Contributor

QlikView12

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;

Labels (1)
0 Replies