How to get the lowest value in a text object

[tungogers_mbps]

Hi,

How do I create a text object with these:

 The text object should look like this " For Week [Week], [Team Name] has the lowest volume of [Score]"

The week is Max(Week).

I'm new to Qlikview

Thanks!

[Taoufiq_Zarra]

@tungogers_mbps  can you elaborate ?

can you share a sample data and the expected output in table or file format?

[tungogers_mbps]

Hi Taoufiq,

Due to privacy concerns, I can't share the data. Though I provided the screenshot earlier.

the expected out is 

[Taoufiq_Zarra]

from the shared sample what is the expected value of :

[Week]

[Team Name]

[Score]

[tungogers_mbps]

The expected values are

[Week]: Max Week

[Team Name] Team with the lowest sum of volume

[Score] the lowest sum of volume