how to get maximum date value in text box

[Anonymous]

Hi team,

i am new to Qilk view

i have some issue regarding Max date value in text box

issue :

i have bellow table:

Load * Inline

[

Date,      Delivery%

03/13/2016, 88.1%

03/20/2016, 0.0%

03/27/2016, 0.0%

04/03/2016, 85.1%

04/10/2016, 0.0%

];

in above i want to show max date is :04/03/2016

and i need to show maximum date value:85.1%

because 04/10/2016 Date i dont have any value so in my QVW file i need to show max date is 04/03/2016 and maximum date value:85.1%

please look on attached QVW file

Regards,
Bob

[Kushal_Chawda]

FirstSortedValue({<Delivery%={">0"}>}Delivery%,-Date)

[sunny_talwar]

May be this:

=FirstSortedValue(Delivery%, -Date, 2)

[sunny_talwar]

Even better would be to try these

Max Date

=Date(Max({<Delivery% = {'>0'}>}Date))

Max Date Value

=FirstSortedValue({<Delivery% = {'>0'}>}Delivery%, -Date)

[Chanty4u]

try this

=Firstsortedvalue(delivery%, -Date, 2)

[Anonymous]

Hi stalwar1

you saying correct for that attached QVW but

let us assume:

Delivery%--it is a variable ---variable derived by

NUM(IF(journeyHours>0,Round(((TotalPTDHours))/((journeyHours))* 100,0.1),0),'#,###.#')&'%'

then how can we replicate the bellow condition

=FirstSortedValue({<Delivery% = {'>0'}>}Delivery%, -Date)

Regards,

Bob

[Anonymous]

Hi all,

FYI,

let us assume:

Delivery%--it is a variable ---variable derived by

NUM(IF(journeyHours>0,Round(((TotalPTDHours))/((journeyHours))* 100,0.1),0),'#,###.#')&'%'

then how can we replicate the bellow condition

=FirstSortedValue({<Delivery% = {'>0'}>}Delivery%, -Date)

for more details please look the attached QVW file

Regards,

Bob

[Anonymous]

<<Correction >>

i was attached old QVW file

now please check i am attached new QVD file with along my requirement

Regards,

Bod