how to compare dates in an application

[#1]

I Have a column with date type data. User will select a date from list box. how can i select the date immediately less than the value selected by the user. so that i can fetch other data corresponding to the date immediately less than the date selected from list box.

Thanks for your time....

[#2]

Hi,

I`m not clear about your requirement.

But if you want to select all the date below the selected date, then go for below expression.

=Sum (all if(Date<max(total Date), Sales))

Hope this should help you.

Cheers

- Sridhar

[#3]

No.. No.. There are many experts in this forum...

I just started my life in qlikview

- Sridhar

[#4]

sridhar24784 wrote:
Hi,
=Sum (all if(Date<max(total Date), Sales))

Hi thnaks for reply but this will return sum for all dates below the selected date. i want value for the date which is immidiately below the selected vale

Suppose

Dtae Value

5/09/1998 155

6/09/1998 26

8/09/1998 123

if user select 8/09/1998 then is shall get value for 6/09/1998 which is immediately less to 8/09/1998

Please have a lookk......thanks

[#5]

Hi Dude,

Check the attachment.

You need to go for this below expression.

=date(max(all aggr(sum(all<Date> if(Date<max(total Date), Date)), Date)),'DD-MM-YYYY')

Cheers

- Sridhar

[sathishkumar_go]

Hi

Can u attch ur application here. Then it is easy for solve the problem..........

-Sathish

[#7]

Hi,

One more additional info.

if you wan to select next second max value from the selected date you have to use this following code and by increasing the number in max parameter you can find the next to next max value respectively.

=date(max(all aggr(sum(all<Date> if(Date<max(total Date), Date)), Date),2),'DD-MM-YYYY')

=date(max(all aggr(sum(all<Date> if(Date<max(total Date), Date)), Date),3),'DD-MM-YYYY')

=date(max(all aggr(sum(all<Date> if(Date<max(total Date), Date)), Date),4),'DD-MM-YYYY')

Cheers, Happy Selecting

- Sridhar