Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
srujanaponnuru
Creator
Creator

Backend script mapping problem

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

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

2nd Tab:

srujanaponnuru_1-1637853484958.png

 

3rd Tab:

srujanaponnuru_2-1637853511100.png

 

 

4th tab:

srujanaponnuru_3-1637853531682.png

Please help me on this

Labels (1)
0 Replies