topic Re: Hiding or Masking a (Member ID/Name) Column in App Development

Hiding or Masking a (Member ID/Name) Column

Naude716 — Fri, 16 Feb 2024 20:11:48 GMT

Hi-

I'm new to working in qlik sense. I have a simple table of members that I am sorting based on cost incurred.

For this table I only show the top 20 costing members. I would like to show this without revealing the member's ID/name.

For instance:

I'd like to go from:

Rank Name Cost

1 John $50

2 Mike $45

...etc

to simply:

Rank Cost

1 $50

2 $45

... etc

What is the best way to do this? Is there a way to hide a column or alias a name to be equal to it's rank?

Thank you in advance.

Re: Hiding or Masking a (Member ID/Name) Column

Anil_Babu_Samineni — Fri, 16 Feb 2024 20:54:06 GMT

@Naude716 In this case, Why do you need to add this Name as dimension is the first place.

Secondly, You can add for Column If condition as "1=0"

Re: Hiding or Masking a (Member ID/Name) Column

Naude716 — Fri, 16 Feb 2024 21:50:08 GMT

I need it to group the dollar amounts ranked by member ID. Name was just an easy visual example. When I set the "show column when" value to something to make it hide, it will condense all 20 of these member data rows into one row, and sum the dollars.

When the dashboard is published I cannot give out the identities of those top 20 members that had the most cost, but I need to show how much each of the top 20 members incurred in cost separately. Also there are some other columns I need to show other than cost such as primary diagnosis which is something that can't be summed anyways.

Re: Hiding or Masking a (Member ID/Name) Column

rwunderlich — Fri, 16 Feb 2024 23:43:04 GMT

If you are good with anonymizing the Name field throughout your app, you can add this at the end of your script.

AutoNumber Name;

-Rob

Re: Hiding or Masking a (Member ID/Name) Column

Naude716 — Mon, 26 Feb 2024 02:09:18 GMT

Thanks, that is a perfectly acceptable answer. Is there anyway I could have an autonumber'd ID and preserve the original variable side by side?

I tried: AutoNumber Name as 'AnonID';

-but the loader did not like that.

Re: Hiding or Masking a (Member ID/Name) Column

rwunderlich — Mon, 26 Feb 2024 16:34:18 GMT

Load the field twice when you load the source, then autonumber one of them.

Load
Name,
Name as NameOriginal,
From ....;

AutoNumber Name;

-Rob

Re: Hiding or Masking a (Member ID/Name) Column

Naude716 — Mon, 26 Feb 2024 16:36:25 GMT

Thank you very much!

That is a big help.