2 Replies Latest reply: Jul 8, 2016 6:07 AM by Rajan Kumar RSS

    How to make "-" fields clickable

    Lucas Bergmann

      Hi,

       

      in my work i have a few charts like this:

      example.PNG

      How can I make the grey part choosable?

       

      For better understanding, this is what the table looks like:

       

      Table 1, Objects:

      Object Name
      Object 1

      Object 2

      Object 3
      Object 4

       

      Table 2, Tags:

      Object NameTag
      Object 1Local
      Object 2Local
      Object 3Global

       

      The measure is just a count of the object names.

       

       

      I think what I need is a formula for the data editor, that does this:

      IF the Object has no tag THEN give it the tag "-"

       

      How do I put that into qlik syntax in in which part of the editor do I insert that?

       

       

      I would really appreciate your help!