Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alexcastorena
New Contributor

Masking Names

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
3 Replies
paul_scotchford
Valued Contributor

Re: Masking Names

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

You could try it with an expression like this:

if(getselectedcount(Customer) = 1,

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

     Customer)

- Marcus

alexcastorena
New Contributor

Re: Masking Names

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

Community Browser