topic Re: Load Script If Help in QlikView

Load Script If Help

Thu, 17 Sep 2015 21:27:08 GMT

I keep getting Invalid Expression with the following load script:

Insource%:

Load

AcctDesc,

Cost,

If(AcctDesc='Demand Service' or AcctDesc='Demand Parts',Sum(Cost),0)/Sum(Cost) as Insource

Resident MasterCostTable;

maxgro — Thu, 17 Sep 2015 21:37:28 GMT

- add a group by

- I don't understand the if, it seems sum(Cost) / sum(Cost) or 0 / sum(Cost), so 1 or 0

Insource%:

Load

AcctDesc,

Cost,

//If(AcctDesc='Demand Service' or AcctDesc='Demand Parts',Sum(Cost),0)/Sum(Cost) as Insource

If(AcctDesc='Demand Service' or AcctDesc='Demand Parts',Sum(Cost),0) as Insource

Resident MasterCostTable

group by AcctDesc, Cost;

Thu, 17 Sep 2015 21:45:58 GMT

The If statement is declaring a subset of costs to divide by the total cost.

datagrrl — Thu, 17 Sep 2015 21:46:33 GMT

What Maxgro said.

Maybe this if you actually want your costs summed up in the script:

Insource%:

Load

AcctDesc,

sum(Cost)as Cost,

sum(If(AcctDesc='Demand Service' or AcctDesc='Demand Parts',Cost,0))/Sum(Cost) as Insource

Resident MasterCostTable

group by AcctDesc;

datagrrl — Thu, 17 Sep 2015 22:08:11 GMT

I am wondering if you wouldn't want to do this in a chart. Then you could use the Total keyword in your expression.