Hi all,
I stuck on the following topic: I do have a table with data which is from one table and I have some premises which are at a different table. So how could I multiply those data from one table with - let say - one figure from a different table?
Code:
Prämissen:
LOAD
"Ø Derivat Stückzahl G30 in Peakzeitraum 2021" as "G30_Fzg/AT",
"Ø Derivat Stückzahl G29 in Peakzeitraum 2021" as "G29_Fzg/AT",
"Ø Derivat Stückzahl J29 in Peakzeitraum 2021" as "J29_Fzg/AT"
FROM [lib://Downloads/7071_MSF_Mengengerüst_V23_QlikSense.xlsx]
(ooxml, embedded labels, table is Prämissen_transponiert);
Verbrauch:
LOAD
Verbaurate_G30,
Verbaurate_G29,
Verbaurate_J29
FROM [lib://LMG_Qlik/Datenbasis_Qlik_MasterGesamtdaten_V8.2-TLC.XLSX]
(ooxml, embedded labels, table is LMG8.2);
As you can see above I do have two different tables such as LMG8.2 and Prämissen_transponiert but there is no possibility to bring those two tables together.
So is there any way I can multiply between two different tables?
Hope I explained my problems and anyone can help?!
Many thanks,
Christian
