topic Re: how to get maximum date value in text box in QlikView

how to get maximum date value in text box

Anonymous — Tue, 31 May 2016 11:30:40 GMT

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

Re: how to get maximum date value in text box

Kushal_Chawda — Tue, 31 May 2016 11:31:54 GMT

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

Re: how to get maximum date value in text box

sunny_talwar — Tue, 31 May 2016 11:33:57 GMT

May be this:

=FirstSortedValue(Delivery%, -Date, 2)

Re: how to get maximum date value in text box

sunny_talwar — Tue, 31 May 2016 11:37:22 GMT

Even better would be to try these

Max Date

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

Max Date Value

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

Re: how to get maximum date value in text box

Chanty4u — Tue, 31 May 2016 11:38:09 GMT

try this

=Firstsortedvalue(delivery%, -Date, 2)

Re: how to get maximum date value in text box

Anonymous — Tue, 31 May 2016 11:58:47 GMT

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

Re: how to get maximum date value in text box

Anonymous — Tue, 31 May 2016 13:07:34 GMT

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

Re: how to get maximum date value in text box

Anonymous — Tue, 31 May 2016 15:59:24 GMT

<<Correction >>

i was attached old QVW file

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

Regards,

Bod