topic Re: Cost Calculation in QlikView

Cost Calculation

qlikwiz123 — Mon, 03 May 2021 19:10:45 GMT

I have the below fields

ID,

Mono,

Group,

Total

CostPerMono,

CostPerGroup

I need to create Costs such that

If an ID has values in either Mono or Group or both,

MonoCost = CostPerMono * Mono

GroupCost = CostPerGroup * Group

If an ID has no values in Mono and Group fields, then

MonoCost = 25% of Total * CostPerMono

GroupCost = 75% of Total * CostPerGroup.

How do I do this in the script ?

Re: Cost Calculation

Vegar — Mon, 03 May 2021 22:35:47 GMT

Try something like below:

LOAD

ID,

Mono,

Group,

Total

CostPerMono,

CostPerGroup,

CostPerMono * alt(Mono, Total*0.25) as MonoCost,

CostPerGroup * alt(Group, Total*0.25) As GroupCost

Re: Cost Calculation

qlikwiz123 — Wed, 05 May 2021 19:08:09 GMT

Hi @Vegar

Thank you. Had to tweak it to check for null values.