topic Re: How to get quarter value based on a minimum values in qlik straight table in App Development

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

dandaanilreddy — Wed, 12 Oct 2022 20:47:47 GMT

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)

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

sergio0592 — Wed, 12 Oct 2022 20:59:34 GMT

Hi, mayabe try with firstsortedvalue() function

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

dandaanilreddy — Wed, 12 Oct 2022 21:21:05 GMT

Hi Sergio

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

Thanks

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

sergio0592 — Wed, 12 Oct 2022 21:28:03 GMT

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

In your case it could be

FirstSortedValue(Quarter, Value)

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

dandaanilreddy — Wed, 12 Oct 2022 21:52:03 GMT

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