Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | $ | Customer | Amount |
---|---|---|---|
Alex | 50 | Cust1 | 50 |
Bob | 10 | Cust2 | 10 |
Jeff | 5 | Jeff | 5 |
Ron | 100 | Cust4 | 100 |
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 ?
You could try it with an expression like this:
if(getselectedcount(Customer) = 1,
if(len(only(Customer)) >= 1, Customer, 'Cust' & rowno()),
Customer)
- Marcus
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