
Contributor III
2024-01-31
01:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Applymap in qlikview
Hi ,
i have this script
Product:
load
id,
descreption
from source;
sales:
load
idproduct,
amount
from source ;
I want this result
id_product,descreption,amount
how can i do it by applymap
thanks
376 Views
1 Solution
Accepted Solutions

Specialist II
2024-01-31
01:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, @Korto2024
The id being the value corresponding to the two Product and Sales tables,
try like the example below:
Products:
mapping
load
Id,
description
from the source;
sales:
load
idproduct,
ApplyMap('Product',idproduct) as per description,
amount
from the source;
https://help.qlik.com/pt-BR/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/Mapping...
Regarts,
Matheus
Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!
367 Views
1 Reply

Specialist II
2024-01-31
01:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, @Korto2024
The id being the value corresponding to the two Product and Sales tables,
try like the example below:
Products:
mapping
load
Id,
description
from the source;
sales:
load
idproduct,
ApplyMap('Product',idproduct) as per description,
amount
from the source;
https://help.qlik.com/pt-BR/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/Mapping...
Regarts,
Matheus
Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!
368 Views
