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: 
krippner
Contributor
Contributor

Show data in a text box according to conditions

Hello, 

i would like to show data in a text box according to a condition. 

The condition would be similiar to:

Show Product where Start-Date is minimum AND Plant = "A".

Therefore i would like to see the Product where the Start-Date is the nearest in a specific plant.

In the settings i can find only an editor where i can put in a measurement.

Thank you for your support. 

 

 

1 Reply
Anil_Babu_Samineni

Perhaps this

If([Start-Date]=Min(TOTAL [Start-Date]) and Plant='A', Product)

Or

If([Start-Date]=Min(TOTAL [Start-Date]) and Plant='A', Concat(Distinct Product, ','))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful