Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
jolio007
Contributor
Contributor

Find the smallest value of a specific column with a key row

I have a column called ref and a column with quantities. Sometimes I have rows that have the same ref but different quantities. I want to be able to get the smaller number from that between the different values. 0683p000009M4r1.pnghere you can see that I have ref with two different qte_T3, I only want 1

Labels (2)
1 Solution

Accepted Solutions
akumar2301
Specialist II
Specialist II

Step 1)  Sort the data based on ref and Qte_T3 ( ascending) 

 

Step2) tAggregateSortedrow

 

group by ref

Calculate 

all other columns with function 1st.

View solution in original post

1 Reply
akumar2301
Specialist II
Specialist II

Step 1)  Sort the data based on ref and Qte_T3 ( ascending) 

 

Step2) tAggregateSortedrow

 

group by ref

Calculate 

all other columns with function 1st.