topic Re: Adding timestamp when no value in QlikView

Adding timestamp when no value

Thu, 17 Jan 2013 09:38:41 GMT

Hello,

I have a database which has a timestamp field against every transaction and I want to display a bar chart that shows the number of transactions every minute, even when there is no data against a timestamp, e.g.

Value	Timestamp
23	2012-01-01 12:45:00
45	2012-01-01 12:46:00
11	2012-01-01 12:47:00
6	2012-01-01 12:49:00
9	2012-01-01 12:51:00

In the above example I would want to the chart to show there is 23 against 12:45, 45 against 12:46, 11 against 12:47, 0 against 12:48, 6 against 12:49, 0 against 12:50 and 9 against 12:51.

My question is essentially is there anyway to add timestamps where no data exists?

Thanks,

Ralph

Re: Adding timestamp when no value

nirav_bhimani — Thu, 17 Jan 2013 09:48:42 GMT

Hi,

You want data like Value Time

eg. 23 12:45:00

then try this in script,

right(TimeStamp,8) as TimePeriod

Regards,

Nirav Bhimani

Re: Adding timestamp when no value

Thu, 17 Jan 2013 09:59:03 GMT

Hello,

What I actually require is that where there are no transactions against a particular time (e.g. 12:50:00 in the above example) that a timestamp is created (either in the script or an expression) and that a value of 0 is attached to this timestamp.

Thanks,

Ralph

Re: Adding timestamp when no value

nirav_bhimani — Thu, 17 Jan 2013 10:12:00 GMT

Hi,

I am not getting what you want, Can you share a demo file.

Regards,

Nirav Bhimani

Re: Adding timestamp when no value

Thu, 17 Jan 2013 11:15:03 GMT

I've attached a test document. As you can see on the chart it has 5 different values spread across 7 minutes (from 23:50 to 23:57), what I want to show is for the minutes that have no data the timestamp but with no data. In other words I want to identify times when there is no output as the chart would be misleading by not showing the particular time.

Thanks,

Ralph