Show only first values of a dimension

[LearnFreak]

Hi,

I have a Straight Table where I have categories per employee. I have 1 column CATEGORY and several values for this column (Category 1 a, Category 1 b, Category 1 c, Category 2 a,  Category 2 b, Category 3 a, Category 4 b,  Category 4 c etc).

I need to show all the values but only of the highest category per employee. Category 1 being the highest and Category 6 being the lowest category.

Have you ever had a case like this?

[Sebastian_P]

Hi,

Check this function:  FirstSortedValue

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/BasicAg... 

[LearnFreak]

I  found this function, yes, but I don't know how to implement it in my case because it is an aggregate function and here I have string values.

[Sebastian_P]

Not sure what You expect but maybe this will help (make a table with this 3 columns):

Employee, firstsortedvalue (CATEGORY, mid(CATEGORY,10,1)), firstsortedvalue (CATEGORY, -mid(CATEGORY,10,1))

Do You want to get 2 columns? Employee, Category (only min and max).

[LearnFreak]

I need to show only the highest Category, for example if an employee has values for all categories I need to show only Category 1 values, if Category 1 is zero then I need to show all values of Category 2 etc....