Simple calculation between sections or tables

[ChrisIAGSense]

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

[Sue_Macaluso]

@ChrisIAGSense Is this for QlikView or Sense?  I want to move this into the correct product forum. This one is typically for general discussion around the community platform. 

[ChrisIAGSense]

It is for Qlik Sense, thanks!