topic Current time in graphs in QlikView

Current time in graphs

Sat, 22 Jan 2011 14:43:43 GMT

How can I set the current time (line) in a graph in Qlikview ?

Current time in graphs

Sat, 22 Jan 2011 16:12:43 GMT

Could you explain the question in detail.

If you want to just show the time in a chart on x-axis/y-axis then you can insert =now() in the text chart and it will display the current timestamp. Is this your requirement?

Current time in graphs

Mon, 24 Jan 2011 09:53:26 GMT

No I want to see a line in the chart (not text).

Current time in graphs

Anonymous — Mon, 24 Jan 2011 10:24:01 GMT

Then just use =now() as an expression in chart.
Is that what you are looking for?

Current time in graphs

Mon, 24 Jan 2011 11:08:50 GMT

I want to see a vertical line that is inidcating actual date/time.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/4718.actual_2D00_timeline.xlsx:550:0]

Current time in graphs

Mon, 24 Jan 2011 11:38:31 GMT

Go to the Chart Properties >> Axes and put a mark on "Continuous". Then go to Presentation tab >> Add Reference line. There write an expression (something like that NUM(MONTH(TODAY())) ) and select "Continuous X".

This way you'll get vertical line on the month which is now.

Current time in graphs

Mon, 24 Jan 2011 11:51:21 GMT

Great. Many thanks it is working.

Current time in graphs

Anonymous — Mon, 24 Jan 2011 11:53:30 GMT

Milda has the right answer and for the expression you can use :

MONTH(TODAY())+ (day(today())/(31))

This gives you a line on the days inbetween the months

(31 should be the last day of the month, I will figure that out later)

Current time in graphs

Anonymous — Mon, 24 Jan 2011 11:59:58 GMT

Founf it:

MONTH(TODAY())+ (day(today())/max(day (Month(today()))))

This will return (today januari 24) : 1,77

Current time in graphs

Mon, 24 Jan 2011 12:03:47 GMT

Many Thanks.

Current time in graphs

Anonymous — Fri, 04 Feb 2011 13:16:40 GMT

Correction:

It should be this:

Month(today()) + Day(today())/Day(MonthEnd(today()))

Good luck.

Re: Current time in graphs

Wed, 24 Apr 2013 07:32:00 GMT

I have a QlikView file where I created a line graph. On x-axies I have Quarters and on Y-axies percentages. Quarters on x-axies are now in this order:

Q1/12, Q1/13, Q2/12, Q3/12, Q4/12

I am using the following expression:

=left(Fiscal_Quarter,2) &'/'& right(Fiscal_Quarter,2)

I want Q1/13 should come to the end.