2 Replies Latest reply: Oct 1, 2015 10:06 AM by Patric Amatulli RSS

    Lookup functionality in qlik (not in script)

      Hi all,

       

       

      I have a problem that i would really like to solve.

       

      The case:

       

      What I want: To show/hide an object for different users based on conditional show.

       

      - Each person has a user ID

      - Each sheet that a user click on has a Sheet ID

      - For each sheet there is a list of names of people with access (Access ID) in a table for whom is allowed to see the hidden object (they can all access the sheet

       

      The problem: The list of names of whom is allowed to see the hidden object contain multiple names (thus multiple Access IDs).

       

      I tried the following logic:

       

      show object if userID = Access ID (field name)

       

      However, when there are multiple people in the Access ID field, qlik returns NULL when i refer to it.

       

      Can someone help me with this issue?

       

       

       

       

      NOTE: 'I need to make this logic work when changing the sheet (thus the list of Access IDs changes)

       

       

      Thanks ya'll smart individuals for helping me!!!