Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
alexcastorena
Contributor III
Contributor III

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
Specialist
Specialist

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 ?

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

alexcastorena
Contributor III
Contributor III
Author

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