Getting top1 row from each category from table

[vimalmanavalan]

hello Qliksense users,

I'm new to Qliksense and got stuck on getting one logic to convert below data to filter top1 rows of each category.

Expected output should have only one row/name related information.

can anyone put some light on my query .?? how to acheive it.?

INPUT DATA TABLE
NAME	CATEGORY	PRIORITY
SHOP1	APPLE	1
SHOP4	TOMATO	4
SHOP3	PINEAPPLE	3
SHOP1	GRAPES	2
SHOP2	APPLE	1
SHOP5	TOMATO	4
SHOP2	PINEAPPLE	3
SHOP2	GRAPES	2
SHOP3	GRAPES	2
SHOP5	ROSE	5
SHOP4	ROSE	5

EXPECT OUTPUT
NAME	CATEGORY	PRIORITY
SHOP1	APPLE	1
SHOP2	APPLE	1
SHOP3	GRAPES	2
SHOP4	TOMATO	4
SHOP5	ROSE	5

[MayilVahanan · Accepted solution]

HI @vimalmanavalan 

Try like below

Exp: FirstSortedValue(CATEGORY, PRIORITY)

For Priority, you can use Min(PRIORITY) also

[vimalmanavalan]

Excellent, Thanks for the suggestion 🙂