I want to map the 'Kasse' and 'Share%' column of the above table A(excel sheet) to 'Depot' of another existing table B and then want to multiply the 'Share%' with the 'Total commit' field in the table B.
How can I use this in qliksense? Do I need mapping and applymap function?
(ooxml, embedded labels, table is Tabelle1)
Applymap(Map_A, Depot) as Pensionseinrichtungen,
Share%*[Total Commit] as Real Total Commit
How can I use the Share% in table A as a measure in table b with or without mapping?
Should I use inline mapping function or resident/preceding load?
i want to modify my report script actually...The tables A nad B are already joined and the kasse is also previously mapped to depot.But I want to add the share as a new column in the exisiting table A so that I dont have to hardcode it and use it as a variable mapped to the correct Kasse.
If(Match([Pensionseinrichtung], 'MER'),Sum( [Total Commit] *0.0099),
If(Match([Pensionseinrichtung], 'CONTI'),Sum( [Total Commit] *0.02,
If(Match([Pensionseinrichtung], 'HPF EK'),Sum( [Total Commit] *0.0008,
I dont want to use this shares as a hard code but use a fiield Share% in this regard.What could be the optimal solution
i want to use the share% field which is contained in the comment
Applymap(Map_A, Depot) where Map_A contains Kasse and also Share%. How can I use the share% field?
Not clear what you mean by Map_A contains Kasse and also Share%.
I think there maybe a misunderstanding of what a map is.
Map is a key value field
i.e. you map a key e.g. MER to a a value (share) 0.0099
so if you do applymap('Map-A','MER') you will back 0.0099
What if applymap('Map-A','MER')
Can Map-A(from table A) contain both values of Kasse Name and Also share?
If I want to map INTO MER into a new destination table, should i have to create this new field or the field will be created automatically?
For example the share is not present in table B but the kasse name is present.I want to retrieve values of share from table A to table B