topic Re: Get Max date and max value of a End time in App Development

Get Max date and max value of a End time

abc_18 — Sat, 16 Nov 2024 03:28:25 GMT

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

Re: Get Max date and max value of a End time

Kashyap_R — Fri, 24 Jan 2020 10:05:56 GMT

please go through the attached Qvf file

Hope this helps

Thanks

Re: Get Max date and max value of a End time

abc_18 — Fri, 24 Jan 2020 11:51:23 GMT

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

Re: Get Max date and max value of a End time

Kashyap_R — Fri, 24 Jan 2020 12:05:57 GMT

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