Date functions with overlapping days causing distortions in Chart

Wed, 12 May 2010 16:54:49 GMT

Hi guys,

I have a problem which i'm not sure how to overcome. I have a requirement in which i want to display a

time/date value as the expression
Date as the x-axis

Initially I had trouble with formatting the data but I managed to use the subfield function which helped with this.

My time/date values span across days. You can see the problem I have within the sample app I have attached.

The problem is that when subfield is used (and I deem necessary as the chart won't work without it) and a timeoverlaps to a new day, it doesn't display correctly. I have attached text boxes in my app to explain my predicament better. I've tried a large number of options but don't see how I can get my chart to work. If anyone has any ideas, please feel free to comment. Thanks alot.

Date functions with overlapping days causing distortions in Chart

johnw — Thu, 13 May 2010 01:19:48 GMT

I am unclear what you want the data at 05/05/2010 to actually be. Are you trying to show the elapsed time from the start of the business day to the "Value" timestamp? So for 05/05/2010 you don't want 00:25:42 but actually 24:25:42? In that case, you'd want something like this:

interval(timestamp#(Value,'DD/MM/YYYY hh:mm:ss')-date#("Business Date",'DD/MM/YYYY'),'hh:mm:ss') as KPI_Time

topic Date functions with overlapping days causing distortions in Chart in QlikView

Date functions with overlapping days causing distortions in Chart

Date functions with overlapping days causing distortions in Chart