3 Replies Latest reply: Jul 9, 2018 4:58 PM by Alex Castorena RSS

    Masking Names

    Alex Castorena

      Hello,

      Is there any way that a Name can masked in Qlik? I have a customer list though when I select a specific customer I would like the rest of the names to be masked.

      In my example below, If I select Jeff, I would like the rest of the customers to be masked. See the example below.

      Appreciate any help....

           

      Customer$CustomerAmount
      Alex50Cust150
      Bob10Cust210
      Jeff5Jeff5
      Ron100Cust4100
        • Re: Masking Names
          Paul Scotchford

          When you say mask do you mean you want to not show the other customers  after Jeff or any other customer is selected ?

           

          When you select a dimension (e.g. Jeff)  on a chart then only that dimension will be displayed i.e. Jeff

           

          This is the way the associative engine works.

           

          Or do you require something else ?

            • Re: Masking Names
              Alex Castorena

              Hi Paul,

              I would like the other customers detail to still show, though not display their original name.

              So in the example I provided. If I select Jeff, i would like so see all the other customers with a masked named.

              Example Alex would display Cust1, Bob would display, Cust2, Ron would display Cust4

            • Re: Masking Names
              Marcus Sommer

              You could try it with an expression like this:

               

              if(getselectedcount(Customer) = 1,

                   if(len(only(Customer)) >= 1, Customer, 'Cust' & rowno()),

                   Customer)

               

              - Marcus