Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try
= 'Lost qty = ' &( Sum({<Date={'$(=MIn(Date))'}>} Qty1+Qty2) - Sum({<Date={'$(=Max(Date))'}>} Qty1+Qty2))
Thank you Sasidhar Parupu