Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Gurus,
In QlikSense I have one table with the following fields (among others):
[DateID] that is represented as DD/MM/AA hh:mm:ss
[Date] that is represented as DD/MM/AA (extracted from DateID),
[Month] that is represented as MM/AA (extracted from DateID),
[Temperature] <-- I have one record for each [DateID]
I would like to have the following calculations when selecting a [Month] or [Date] os [Date ID Range]:
Start Temperature: Temperature in the beginning of the selected date
Final Temperature: Temperature in the end of the selected date.
How can I reach it?
Thanks in advance.
Hi Jordi,
Try this:
only({<Date={"$(=Date(min(Date)))"}>} Temperature)
only({<Date={"$(=Date(max(Date)))"}>} Temperature)
Regards,
Sorin.
Thank you very much for your response but it's not working....
Probably due to your date format. Maybe:
only({<Date={"$(=Date(min(Date),'DD/MM/AA'))"}>} Temperature)