Discussion Board for collaboration related to QlikView App Development.
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))
stupid typo, I found it.
View solution in original post