Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

qlikoytun
New Contributor

Restriction Problem in Set Analysis

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!

1 Solution

Accepted Solutions

Re: Restriction Problem in Set Analysis

Try this

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

1 Reply

Re: Restriction Problem in Set Analysis

Try this

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

Community Browser