Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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