Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ext_bks
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!

Labels (3)
1 Solution

Accepted Solutions
Seyko
Partner
Partner

Hello,

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

cordially.

Excuse my english, i'm french!

View solution in original post

2 Replies
Seyko
Partner
Partner

Hello,

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

cordially.

Excuse my english, i'm french!

View solution in original post

ext_bks
Employee
Employee
Author

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!