Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Offset the 24 hour period of a daily report

Hi,

I have a report which shows the financial transactions total for users in the database. Currently, when a single day is selected on the calendar, this shows users total transactions for the 24hr period of that selected day (from Midnight to Midnight).

Is it possible to offset the 'day' of this report so that the 24hr period being shown is actually 3am to 3am?

I would like to achieve this without affecting other reports. In other words, I want to keep the current setting (Midnight to Midnight) for all other existing reports, but only change the setting for this one report (3am to 3am),

Any help would be greatly appreciated.

Thanks,

Peter

4 Replies
Highlighted
MVP
MVP

Peter,

you could add an additional field to filter your timestamps accordingly, using daystart with additional shift parameter:

LOAD

..

TransactionTimestamp,

Date(daystart (TransactionTimestamp, 0, 0.125),'YYYY-MM-DD') as CustomWorkingDay,

...

from TransactionTable;

Or use similar in your chart expressions.


Highlighted
Not applicable

Thanks for the suggestion.

I'll try it out and let you know.

Highlighted
Not applicable

Hi swuehl,

That worked perfectly. I was able to create another calendar day selector in my document which shifted the day by three hours.

Thanks you very much.

Peter

Highlighted
Not applicable

hi Swuehl,

I have similar problem and I need Hrs from 06 to 05.

Can you help me. My code and example is in this thread.

http://community.qlik.com/message/305015#305015