Qlikview set analysis filter based on multiple fields

[#1]

I am fairly new to Qlik (not to programming) and trying to get the following to work:

sum({1< [perc] = {" >= 0.9"}, [ap] = {"fabs([ap]) >10000"}, [flag] = {"NO"} >}[ap])

I have tried with just [perc] = {" >= 0.9"} and without the '1' before the < and there is no data to display.  However I know that there is.  Have I got the expression wrong?

In Pandas-I would possibly need to tell it what 0.9 or 10000 or NO are, by changing the data type to number or integer or string...-could this be the problem?

Thanks for any help! Much appreciated!

[JonnyPoole · Accepted solution]

I was testing this and the space between the "  and the >  matters.

Change:

sum({1< [perc] = {" >=0.9"} >} [ap] )

to

sum({1< [perc] = {">=0.9"}>}

[#3]

WOW! good catch, I am used to putting spaces in for formatting.  I haven't figured out how to get it to work with the full expression but it's likely something along the same lines.  Thanks so much!

[JonnyPoole]

Super. If its working now kindly mark helpful/correct answers and close the thread.  It helps others find solutions to similar questions.