topic exclude values within a range in set analysis in QlikView

exclude values within a range in set analysis

curiousfellow — Mon, 04 Apr 2016 13:17:32 GMT

I want to sum values within a range of accountnumbers, and exclude some accountnumbers

this expression goves results

=Sum({$<A3XMCD={">$(=400000)<$(=799999)"}>}Amount)

but when i want to exclude an accountnumber with this expression :

=Sum({$<A3XMCD={">$(=400000)<$(=799999)"},A3XMCD-={404010}>}Amount)

I don't get any results

Both expressions were made with the set analysis wizzard

And still strugling with set analysis syntax

Gysbert_Wassenaar — Mon, 04 Apr 2016 13:19:36 GMT

Try =Sum({$<A3XMCD={">400000<799999"}-{404010}>}Amount)

swuehl — Mon, 04 Apr 2016 13:20:28 GMT

Try

=Sum({$<A3XMCD={">$(=400000)<$(=799999)"} - {404010}>} Amount)

No two field modifiers for the same field, please

curiousfellow — Mon, 04 Apr 2016 14:15:18 GMT

Thank you both. did not know this. Still learning

Chanty4u — Mon, 04 Apr 2016 14:17:01 GMT

chk dis tooo

swuehl — Mon, 04 Apr 2016 14:25:18 GMT

You are welcome.

If your issue is resolved, please consider closing this thread by marking helpful and correct answers.