Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

how to create time range for every 30mins and display in bar chart

Hi, how do I create time range for every half an hour and display in bar chart? I have a list box called timediff that displays the time intervals I derived between 2 columns. I've been trying many codes but nothing just seems to work. Thanks.

2 Replies
Not applicable

Re: how to create time range for every 30mins and display in bar chart

Maybe try define dimension with class() function

Not applicable

Re: how to create time range for every 30mins and display in bar chart

Hi Rachel, you need round your actual transaction timestamp into 30 mins window.

Try like below:

LOAD *,

     Timestamp (floor(TRANSACTION_DATE,30/(24*60) )) AS TRANS_DATE_30MIN

from QVD;

Use this new field as the dimension.