topic Re: Show only first values of a dimension in App Development

Show only first values of a dimension

LearnFreak — Wed, 19 Oct 2022 07:09:46 GMT

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?

Re: Show only first values of a dimension

Sebastian_P — Wed, 19 Oct 2022 07:18:14 GMT

Hi,

Check this function: FirstSortedValue

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

Re: Show only first values of a dimension

LearnFreak — Wed, 19 Oct 2022 07:21:16 GMT

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.

Re: Show only first values of a dimension

Sebastian_P — Wed, 19 Oct 2022 07:42:10 GMT

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).

Re: Show only first values of a dimension

LearnFreak — Wed, 19 Oct 2022 09:25:09 GMT

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