topic Calculated dimension - invalid error message in App Development

Calculated dimension - invalid error message

blunckc1 — Mon, 20 Dec 2021 21:02:46 GMT

Hi community,

I am have written this nested if statement as a calculated dimension, but I keep getting an invalid dimension error...

=if(sum([CrtEmp.ContractedFTE])=0,'100% vacant',
if(sum([CrtEmp.ContractedFTE])>0 and sum([CrtEmp.ContractedFTE])<PosData.PlannedFTE,'Partially filled',
if(sum([CrtEmp.ContractedFTE])=PosData.PlannedFTE,'Fully filled',
if(sum([CrtEmp.ContractedFTE])>PosData.PlannedFTE,'Over established','LogicEnd'))))

This works perfectly fine when I include it into a table as a measure though, so I don't understand what's going on...

Note the "Occupany Status" is a dimension that is calculated in the load script. But want to convert this to a calculated dimension so it can dynamically change when a filter that shows who is actively working or not is used.

Re: Calculated dimension - invalid error message

rwunderlich — Fri, 12 Mar 2021 03:13:48 GMT

You need to wrap that entire expression in an Aggr() that specifies the dimension(s) to use for the Sum() aggregations. For example

Aggr( your if expression, [Position Id])

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Calculated dimension - invalid error message

blunckc1 — Fri, 12 Mar 2021 03:18:11 GMT

Total der moment there... Ha. Thanks mate!!