Error in expression

[Beginner_Qlik1]

Hi,

I want to sum of all Values for which ValueCategoryGlobal are "06-CIP Cold Water Consumption" and "06-CIP Hot water Consumption" and BatchTypeGlobal starts with "CIP". What is worng with my expression.

Could somone help ?

[BrunPierre]

Do this in place of the WildMatch.

..., BatchTypeGlobal={"CIP*"}>} Value)

[maxgro · Accepted solution]

for BatchTypeGlobal starts with "CIP" you can use 

sum({$<BatchTypeGlobal={"CIP*"}>} Value)

[rwunderlich · Accepted solution]

The BatchTypeGlobal modifier should be:

BatchTypeGlobal={"CIP*"}

-Rob

[Beginner_Qlik1]

Thanks all for your help.