Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
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.