Qlik Community

Qlik Sense App Development

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

Highlighted
Employee
Employee

Need help with field mapping

Hi all,

I am thinking along the lines of applymap but I am uncertain how to achieve this. My datasource is excel file and the tables something like this:

Table Project:

Project ID Project Status
Proj A ?
Proj B ?
Proj C ?


Table Tasks:

Project ID Tasks Task Status
Proj A Proj A-Task 1 Complete
Proj A Proj A-Task 2 In Progress
Proj A Proj A-Task 3 Not Started
Proj B Proj B-Task 1 Complete
Proj B Proj B-Task 2 Not Started
Proj C Proj C-Task 1 Complete
Proj C Proj C-Task 2 Complete

 

I would like to add a new column called Project Status in Project Table, by looking up Task Table. If All tasks related to a project is marked as Complete, then my Project Status will be complete. If It is a mix of Complete, In Progress and Not Started then Project Status as In Progress, and if everything is Not Started then Project Status as Not Started

So the result in Project Table will be:

Proj A - In Progress

Proj B - In Progress

Proj C - Complete

 

Appreciate you help very much!

Thanks!

1 Solution

Accepted Solutions
Partner
Partner

Re: Need help with field mapping

Hello,

Use the example in attachment. It should work, normally.

cordially.

2 Replies
Partner
Partner

Re: Need help with field mapping

Hello,

Use the example in attachment. It should work, normally.

cordially.

Employee
Employee

Re: Need help with field mapping

Hi Seyko,

Thank you, your app works great! Does exactly what I wanted but in my app somehow it's not working. I've sent a private message with my code.

Thank you very much!