topic Re: Using a timestamp is set analysis in QlikView

Using a timestamp is set analysis

nicalbert — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I have been using this set analysis to show some KPIs for "yesterday" (i.e. today - 1), and it works really well:

=count({<ReceivedTimeStamp = {'>=$(=DayStart(today()-(1))))<$(=DayStart(today()))'},
Code = {1,2,3,4}>}
DISTINCT RunID)

I now need to modify it to show the same KPIs, but for a time period that goes from yesterday at 0700 to today at 0659. It's still a 24hrs period, but covering 2 days.

I'm totally lost with this one!!! Can anyone provide some guidance on how to achieve that? Or if this can be achieved at all...

Thanks!

Nic

Re: Using a timestamp is set analysis

Kushal_Chawda — Mon, 24 Aug 2020 23:41:39 GMT

Assuming your time field is in proper timestamp format then you can try below. You can adjust the hours and minutes in maketime function within set.

Note: Maketime function always takes parameters as 24 hours format. So 3 PM can be written as maketime(15,00)

=count({<ReceivedTimeStamp = {">=$(=timestamp(floor(Today()-1)+maketime(07,00)))<=$(=timestamp(floor(Today())+maketime(06,59)))"}, Code = {1,2,3,4}>} DISTINCT RunID)

Re: Using a timestamp is set analysis

nicalbert — Tue, 25 Aug 2020 22:17:20 GMT

you totally made my day here! Your solution is exactly what I was looking for.

Thank you very much,

Nic