How to get quarter value based on a minimum values in qlik straight table

[dandaanilreddy]

Hello All

I have a straight table with 9 expressions using each quarter for each expression. I created another expression to show Min value comparing all the 9 quarters values. Now i want to create one more column to show that min value quarter name.

Example: For one of my product i see min value is in 2021Q1 when compared the 9 quarters values. so In a new column user want to see the quarter name which is 2021Q1. Please can someone let me know how can i achieve the quarter name.

Expression for min value for each product:

min({<company={'$(vcompany)'}>}value)

[sergio0592]

Hi, mayabe try with firstsortedvalue() function

[dandaanilreddy]

Hi Sergio

Thanks for your response. Please can you give me sample expression for the above?

Thanks

[sergio0592]

Take a look here
https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/Aggrega... 

In your case it could be

FirstSortedValue(Quarter, Value)

[dandaanilreddy]

Thank You Sergio.

This expression is not giving me the correct quarters in my straight table with existing expressions but if i take only this expression its showing the expected results using product as my dimension but user wants to see the quarter names next to min value column.

Thanks