Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this
Sum({<ID = {'4.*'} - {'4.11','4.12'}>} sales)