Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rrrggg20
Contributor II
Contributor II

Cost mapping to newly created fields

Hello all, 

I have a question about mapping costs for a project to dynamic fields and placing them in the correct cells.

The scenario is:

there are multiple projects, whose phases are determined by the milestone dates within the activities of the project

The costs are estimated by multiple people

The problem is I need to roll these costs up by they cost type (dynamic) then put them in the year month that they fall in the project.

I have the project phases created and costs loaded, I am trying to do something like this (in variables)

The costs would come in from Dept1, Dept2, Dept3.

I am trying to map Dept1 and Dept2 to COSTTYPE1 and Dept2 to COSTTYPE2

Something like this

(This is in Variables, not a load script.)

I have tried vExternal =:

if(COSTSOURCE = 'Dept1' OR COSTSOURCE = 'Dept3', $(Cost))

if(COSTSOURCE = 'Dept1' OR COSTSOURCE = 'Dept3', Cost)

vExternal = if(COSTSOURCE = 'Dept1' OR COSTSOURCE = 'Dept3',sum(Cost)) 

 

any help is appreciated

 

However the cost is not coming through.

I have tried if(COSTSOURCE = 'Dept1',$(Cost))

 

 

1 Solution

Accepted Solutions
rrrggg20
Contributor II
Contributor II
Author

stupid typo, I found it.

View solution in original post

1 Reply
rrrggg20
Contributor II
Contributor II
Author

stupid typo, I found it.

View solution in original post