Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current time in graphs

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

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

11 Replies
Not applicable
Author

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?

Not applicable
Author

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

Anonymous
Not applicable
Author

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

Not applicable
Author

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]

Not applicable
Author

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.

Not applicable
Author

Great. Many thanks it is working.

Anonymous
Not applicable
Author

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)

Anonymous
Not applicable
Author

Founf it:

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

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

Not applicable
Author

Many Thanks.