Restriction Problem in Set Analysis

[Anonymous]

Hi to all,

In qlik sense, i would like to restrict my ID field in my set analysis in

such a way that i only want to pick all values which start with 4 but

does not contain 4.11 and 4.12. I tried this but it does not work.

sum({<ID={'4.*'}, ID=-{'4.11','4.12'}>} sales)

‌Does anyone know how to do that?

thanks in advance!

[sunny_talwar · Accepted solution]

Try this

Sum({<ID = {'4.*'} - {'4.11','4.12'}>} sales)