exclude values within a range in set analysis

[curiousfellow]

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]

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

[swuehl]

Try

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

No two field modifiers for the same field, please

[curiousfellow]

Thank you both. did not know this. Still learning

[Chanty4u]

chk dis tooo

Excluding values in Set Analysis

[swuehl]

You are welcome.

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

Qlik Community Tip: Marking Replies as Correct or Helpful