6 Replies Latest reply: Dec 16, 2016 12:47 PM by Mufaddal Borsadwala RSS

    Section access with wildcards

    Mufaddal Borsadwala

      From one of the threads (section access and application access)

      Example:Several.png

      This table you would interpret as "A can see the data if (Shop=X and Product=ANY) or (Shop=ANY and Product=Y)". But QlikView interprets it the other way around: "A can see data if (Shop=X or Shop=ANY) and (Product=ANY or Product=Y)". So it won't work. A will be able to see everything.



       

       

       

       

       

       

       

       

       

       

      This blog explains how to achieve this using concatenation of the field values and a Bridge which is great!

       

      Is there a way to support wildcards such as below:

       

      USER%AUTHID
      AX|P*
      AS*|Y

       

      In query terms it would be something like :

       

      (shop=X and product like 'P%') or (shop like 'S%' and product = Y)

       

      Regards,

      Mufaddal