Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
@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"
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.
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
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.
Load the field twice when you load the source, then autonumber one of them.
Load
Name,
Name as NameOriginal,
From ....;
AutoNumber Name;
-Rob
Thank you very much!
That is a big help.