Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

segerchr
New Contributor II

Mapping and sum()

Hi,

i need a solution to map a distinct datafiled to another table.

Table1:

Gewerk Price Work   
Building   150Roof
Planning   100Kitchen
Building     50TV

Table2:

Gewerk PriceREAL  PRICEFUTURE
Buliding  350400
Planning   250150

Taget:

Gewerk, PriceREAL,   PRICEFUTUREPriceNEW
Buliding  350400200
Planning   250150100

The Target contains the distinct sum() of table1.

How can I map the distinct data of Table1 to Table 2 ?

Thanks for helping.

CS

1 Solution

Accepted Solutions
MVP
MVP

Re: Mapping and sum()

Answered it here -> Mapping load and sum()

1 Reply
MVP
MVP

Re: Mapping and sum()

Answered it here -> Mapping load and sum()