Qlikview conditional help needed

Dallas1000 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Qlikview conditional help needed

tresB — Wed, 04 Sep 2019 06:52:25 GMT

Try like:

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

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

Dallas1000 — Wed, 04 Sep 2019 08:29:45 GMT

Much appreciated!