Latest\Earliest Value

[#1]

Hello,

I am new in Qlik.

I have asked this question in the past but now I created an example for my data ( I am working with SQL DB but I hope this example will do).

I wish to show, calculate, find the earliest and the latest value (by date) from my Data Base. (See text Box in red)

Not the Max or Min value!

I have searched for the formula in the forum but with no success.

Can any one help?

Thank you

Nir

[sasiparupudi1]

try

= 'Lost qty = ' &( Sum({<Date={'$(=MIn(Date))'}>} Qty1+Qty2)  -  Sum({<Date={'$(=Max(Date))'}>} Qty1+Qty2))

[#3]

Thank you Sasidhar Parupu