Get Max date and max value of a End time

[abc_18]

It's possible to get a max value of a max date, of max 'End time' using expressions in Qliksense ?

Table:-

End time	Closing value	Date	Financial month
2019-11-25 19:00:00.0000	10646.406	2019-11-25	Nov
2019-11-25 19:00:00.0000	13093.776	2019-11-25	Nov
2019-11-25 20:00:00.0000	18038.217	2019-11-25	Nov
2019-11-25 21:00:00.0000	10687.71	2019-11-25	Nov
2019-11-30 21:00:00.0000	678678	2019-11-30	Nov

Result (Based on month selection):- for Nov month max of date is 30th

End time	Closing value	Date	Financial month
2019-11-30 21:00:00.0000	678678	2019-11-30	Nov

Result (Based on date selection):- if user selects date as 25th Nov, then Max slot of End time

End time	Closing value	Date	Financial month
2019-11-25 21:00:00.0000	10687.71	2019-11-25	Nov

I have attached screenshot here for reference, which display two line charts, first one is for month selection and another one is for date selection, similarly I have to create in Qliksense.

@Kashyap_R , @Gysbert_Wassenaar @Prashant , tagging you guys, please help.

Regards

[Kashyap_R]

Hi

please go through the attached Qvf file 

Hope this helps 

Thanks

[abc_18]

Hi Kashyap,

Thanks for the response, it's working fine in your sample file.

I have tried to implement same in my app as you suggested, but I am getting error as attached here.

I am using below formula:-

Sum({<[bkt_end_time]={"$(=FirstSortedValue([bkt_end_time],-Time([bkt_end_time])))"},sap_invoice_date=>}[closing_inventory])

Do I need to change the bkt_end_time format?, please suggest.

It's not reading 'bkt_end_time ', value just returning blank.

Regards

[Kashyap_R · Accepted solution]

Hi

please make sure that the [bkt_end_time] is not in string format.

if it is in string try to format according to your requirements

Thanks