topic Showing today on a chart in QlikView

Showing today on a chart

Dayna — Thu, 10 Feb 2011 11:01:10 GMT

Hello All,

This might sound silly, but I want to make it obvious on a bar or line chart where today is. I have multiple dimensions and expressions, and one of the dimensions will be date or week/year.

I was thinking of doing an IF statement on the colour to change for today(), but then the legend gets screwed up..

Any ideas? I just want to make it obvious to the users where the current date is on the chart!

Kind Regards,
Dayna

Showing today on a chart

deepakk — Thu, 10 Feb 2011 11:14:36 GMT

hi Dayna,

PFA

Showing today on a chart

Dayna — Thu, 10 Feb 2011 11:24:56 GMT

Hello Deepak,

Thank you for your quick reply, unfortunately if you have more than one expression the legend doesn't work...

Kind Regards,

Dayna

Showing today on a chart

deepakk — Thu, 10 Feb 2011 11:54:45 GMT

hi,

Then in each expression you have to do it.

Showing today on a chart

Dayna — Thu, 10 Feb 2011 12:06:27 GMT

Hello Deepak,

That isn't the solution I need, as I have already done it (please see my original post).

If one of my dimensions is Part, then I want the legend to show a different colour for each part (20+), but using the colour in the chart will break this which is no good. I need the users to be able to view which line belongs to each site/part.

I already did your original post but changed the colour to black for each expression, but this won't work.

Regards,
Dayna

Showing today on a chart

deepakk — Thu, 10 Feb 2011 12:17:43 GMT

HI Dayna,

Can you attach a sample file, I will like to see it.

Showing today on a chart

Dayna — Thu, 10 Feb 2011 12:57:55 GMT

Hello Deepak,

Please find attached, this isn't my data but will present my problem.

Dayna

Showing today on a chart

deepakk — Thu, 10 Feb 2011 13:08:13 GMT

HI Dayna,

If legend is a problem. It would be better to disable it and use a text object to display legend

like create green color text box and write a name as FLN. Similarly for Others. IN this way you will be able to show an indication to user on Today date and also will be able to show the legends.

Showing today on a chart

Dayna — Thu, 10 Feb 2011 13:12:53 GMT

This is only a small example, in my actual application I would have 100+ products shown, so it wouldn't be feasible.

Is there any other route I could go down, instead of changing the colour of the bar maybe add another bar or blob that shows todays date?

Showing today on a chart

deepakk — Thu, 10 Feb 2011 13:41:27 GMT

hi,

How about changing only the text color instead of Background.?

Showing today on a chart

Dayna — Thu, 10 Feb 2011 13:48:35 GMT

It might be an option, but doesn't work for me.. can you try on your sample?

Kind Regards,
Dayna

Showing today on a chart

lironbaram — Thu, 10 Feb 2011 14:11:37 GMT

hey attach

is my suggestion

adding an expression which Write Today Above the correcet date

Showing today on a chart

Anonymous — Thu, 10 Feb 2011 14:37:15 GMT

Hi Dayna,

Maybe this is what you are looking for?

Check file.

Showing today on a chart

Dayna — Thu, 10 Feb 2011 15:53:36 GMT

Hello Dennis,

That's exactly what I was after! Thank you!!

Showing today on a chart

Dayna — Thu, 10 Feb 2011 15:57:58 GMT

Dennis, how did you do it? lol!

Showing today on a chart

Anonymous — Thu, 10 Feb 2011 17:11:39 GMT

Hi Dayna,

I used the "Reference Lines" option in the presentation tab

If you open my document and you go there you will see "today", select this and click "Edit", you will see the expression and the options I used to make this line:


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

Because my grahp has months it has to return the right month and the amount of day (from the current month) devided by the total days of the current month.

So for today (feb 10) it will return 2 (=month) , 10/28 (day 10 of 28) = 2,35714

I hope you can use this and adjust it to your needs.

Showing today on a chart

Dayna — Thu, 10 Feb 2011 17:23:57 GMT

Hello Dennis,

Many thanks for the above, I have only one last question... Continuous X is greyed out for me, how did you get this option?

Kind Regards,
Dayna

Showing today on a chart

Anonymous — Thu, 10 Feb 2011 17:48:43 GMT

I found:

Continuous X requires that you have a numeric value on the X-axis and have chosen to display it as continuous on the axis tab.

Here: http://community.qlik.com/forums/t/28348.aspx