Hi Team,
I have a requirement as below. From first three tabs , i took the data to the fourth tab.
From first three tabs there is no value stream , so i applied applymap and got the valuestream to the main mapping file.
my code is as below:
![srujanaponnuru_6-1637854429163.png srujanaponnuru_6-1637854429163.png](https://community.qlik.com/t5/image/serverpage/image-id/67465i8EF70EE0D99DF92C/image-size/medium?v=v2&px=400)
output i am getting like this, but i am not getting ValuestreamCost% and ValuestreamFTE% for the Area functions. It should come as 100% in both the values. i applied applymap for both the fields but it is not coming.
Output |
|
|
|
|
|
|
Level 5 |
Area |
Value Stream |
ValuestreamCost% |
ValuestreamFTE% |
% cost |
% FTE |
A |
ABC |
Toys |
47% |
47% |
100% |
100% |
A |
DEF |
Toys |
53% |
53% |
100% |
100% |
A |
Functions |
Toys |
- |
- |
100% |
100% |
I have one excel file which has four tabs. snippets are below:
First Tab
![srujanaponnuru_0-1637853455325.png srujanaponnuru_0-1637853455325.png](https://community.qlik.com/t5/image/serverpage/image-id/67456i92FD45DE013D0BE3/image-size/medium?v=v2&px=400)
2nd Tab:
![srujanaponnuru_1-1637853484958.png srujanaponnuru_1-1637853484958.png](https://community.qlik.com/t5/image/serverpage/image-id/67458i7E2831DB0C00FC47/image-size/medium?v=v2&px=400)
3rd Tab:
![srujanaponnuru_2-1637853511100.png srujanaponnuru_2-1637853511100.png](https://community.qlik.com/t5/image/serverpage/image-id/67459i29542B2ED836B509/image-size/medium?v=v2&px=400)
4th tab:
![srujanaponnuru_3-1637853531682.png srujanaponnuru_3-1637853531682.png](https://community.qlik.com/t5/image/serverpage/image-id/67461iE62A21DD1B840486/image-size/medium?v=v2&px=400)
Please help me on this