topic Re: KPI Start- End in QlikView

KPI Start- End

jorditorras — Wed, 18 Oct 2017 15:30:49 GMT

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.

isorinrusu — Wed, 18 Oct 2017 15:51:34 GMT

Hi Jordi,

Try this:

only({<Date={"$(=Date(min(Date)))"}>} Temperature)

only({<Date={"$(=Date(max(Date)))"}>} Temperature)

Regards,

Sorin.

jorditorras — Wed, 18 Oct 2017 15:57:54 GMT

Thank you very much for your response but it's not working....

isorinrusu — Wed, 18 Oct 2017 16:10:39 GMT

Probably due to your date format. Maybe:

only({<Date={"$(=Date(min(Date),'DD/MM/AA'))"}>} Temperature)