Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi
please go through the attached Qvf file
Hope this helps
Thanks
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
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