topic Re: In a chart - can I show "today"? in QlikView

In a chart - can I show "today"?

josephinetedesc — Thu, 28 Jan 2016 13:18:28 GMT

Hi All

In a chart which has say monthname(dateOfX) as the x axis - is it possible to have a line or something to signify today's date?

This is probably a bad example,but I hope you understand what I mean.

Re: In a chart - can I show "today"?

sunny_talwar — Thu, 28 Jan 2016 13:33:16 GMT

May be something like this:

Re: In a chart - can I show "today"?

Thu, 28 Jan 2016 13:38:19 GMT

You can try with reference lines on the presentation tab.

Re: In a chart - can I show "today"?

josephinetedesc — Thu, 28 Jan 2016 22:00:09 GMT

Hi Sunny T

Cannot believe it is that easy ... Thank you.

Re: In a chart - can I show "today"?

sunny_talwar — Thu, 28 Jan 2016 22:01:43 GMT

No problem. I am glad I was able to help (although I did not even get helpful for my response )

My bad, I got Correct Now

Re: In a chart - can I show "today"?

josephinetedesc — Thu, 28 Jan 2016 22:05:50 GMT

I sometimes find I am in the incorrect screen for simple things like mark helpful or correct or when I want to download a topic as a pdf.

And … sometimes I think – who am I to mark “correct” ☺

Re: In a chart - can I show "today"?

josephinetedesc — Fri, 29 Jan 2016 04:05:14 GMT

I knew I should never had said easy ...

problem:

the x axis has the formula: Monthname(dateOfActivity) - in order to use the today() I need to make the x axis "continuous" and then the x axis decides to display as a number!

I can actually get it to work with today() - 30 to get last month!

but ... is there any way to fix the date display?

Re: In a chart - can I show "today"?

rajeshforqlikvi — Fri, 29 Jan 2016 04:14:28 GMT

One more option is go to the Presentation Tab -> Test in chart .

You can write today there and you can adjust today any where in the Chart.

Re: In a chart - can I show "today"?

sunny_talwar — Fri, 29 Jan 2016 08:40:02 GMT

Yes, that is indeed a problem and I am not sure if I know a work around. May be re-open this thread by unmarking the correct answer and wait for another response. I am sure there might be a macro that you might be able to use, but I am just not aware of one to suggest you.

Re: In a chart - can I show "today"?

josephinetedesc — Fri, 29 Jan 2016 08:45:56 GMT

i think i hae opened it up for discussion again ...

Re: In a chart - can I show "today"?

sunny_talwar — Fri, 29 Jan 2016 08:48:11 GMT

Good. In case you don't see not many people responding, I would suggest re-creating a new thread by linking it back to this thread.

Re: In a chart - can I show "today"?

Mahamed_Qlik — Fri, 29 Jan 2016 09:06:33 GMT

HI Josephine,

Are you looking something like this ....Please find attachment

Regards,

Mahamed

Re: In a chart - can I show "today"?

Mahamed_Qlik — Fri, 29 Jan 2016 12:18:29 GMT

Hi Rajesh,

I don't think she is looking for just text in chart.

She wants single bar to indicate the today's date present in Date dim.

Please check the above attachment which I have done.

Regards,

Mahamed.

Re: In a chart - can I show "today"?

Fri, 29 Jan 2016 12:24:21 GMT

Hello, Josephine.

I also had this problem and found the solution. When you check the continuous option you can go to the Number Tab and you'll see on the Expression table an entry called "Continuous X-axis" which enable you to choose the correct number format:

Then you can use whatever format you'd like.

Best Regards,

Luis Franco

Re: In a chart - can I show "today"?

Mahamed_Qlik — Fri, 29 Jan 2016 12:37:43 GMT

Hi Josephine,

If you found it is correct answer so appreciate to mark it as correct and close the thread.

Regards,

Mahamed

Re: In a chart - can I show "today"?

MarcoWedel — Sat, 30 Jan 2016 01:17:19 GMT

Hi,

maybe also helpful:

(using Sunny's example file)

regards

Marco

Re: In a chart - can I show "today"?

josephinetedesc — Sat, 30 Jan 2016 12:38:54 GMT

IT WORKS - thank you!

I need to check the other answers but I cannot open QVW files at home (licence limit)

Re: In a chart - can I show "today"?

josephinetedesc — Sat, 30 Jan 2016 12:40:57 GMT

Thanks Marco - I cannot check until I get to work, but will do so first thing Monday morning