Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
JAN. 24, Q&A with Qlik: Making the Move to Qlik Cloud Reporting: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dandaanilreddy
Partner - Creator III
Partner - Creator III

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

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)

Labels (1)
4 Replies
sergio0592
Specialist III
Specialist III

Hi, mayabe try with firstsortedvalue() function

dandaanilreddy
Partner - Creator III
Partner - Creator III
Author

Hi Sergio

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

Thanks

sergio0592
Specialist III
Specialist III

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
Partner - Creator III
Partner - Creator III
Author

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