Qlikview conditional help needed

[Dallas1000]

Good day Qlikview community

I am new here so please be gentle.

I am trying to set a condition in a chart that will only sum values if a text string starts with a certain value.

I have the following expression 

if('Location'='110%',Sum([Total value])) 

my field name with the text that needs to be considered is Location

the text should start with 110%

and the sum should be for the Total value column.

but once I process it the chart does not display the values accordingly.

please assist.

kind regards

Dalton 

[tresesco · Accepted solution]

Try like:

Sum(if(WildMatch(Location,  '110%*'),[Total value])) 

OR

Sum({<Location={"110%*"}>} [Total value]) 

[Dallas1000]

Much appreciated!