1 Reply Latest reply: Jun 29, 2017 12:36 PM by Sunny Talwar RSS

    Restriction Problem in Set Analysis

    Oytun Tunçel

      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!