QlikView App Dev

[#1]

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

[#2]

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?

[#3]

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

[dennisnet]

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

[#5]

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]

[#6 · Accepted solution]

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.

[#7]

Great. Many thanks it is working.

[dennisnet]

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)

[dennisnet]

Founf it:

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

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

[#10]

Many Thanks.