Find max date and min date from selected dates

[ashishpalkar]

Hi There

I have requirement to find Max Date and End Date from selected date range by users.

E.g. Please find attached screenshot.

Thanks for your help!!!

[ashishpalkar]

Thanks , its working Sunny.

[ashishpalkar]

Hi There , 

I have one more requirement

How to find  - 30 days from selected date  and exclude weekends from it.

[sunny_talwar]

May be use firstworkdate - script and chart function ‒ QlikView

[adambrian]

Hi Sunny,

I want to count ID in max date with time range on max date like below, can you help me?

Count({<ActivityDate = {"$(=Date(Max(ActivityDate ), 'YYYY-M-DD'))"},ActivityDate ={'>=09:00:00<=22:29:59'}>}ID)

Count({<ActivityDate = {"$(=Date(Max(ActivityDate ), 'YYYY-M-DD'))"},ActivityDate ={'>=09:00:00'} and ActivityDate = {"$(=Date(Max(ActivityDate ), 'YYYY-M-DD'))"},ActivityDate ={'<=08:59:59'}>}ID)

thanks,

adam

[sunny_talwar]

What is the issue?

[adambrian]

Hi Sunny,

     The issue is that syntax did not make an output..