Date problems

[#1]

Hi all

I've run into two problems with a line chart showing accumulated number of students enrolled per date over a period from March 1st to July 7th.

Problem 1:

The problem is that I want to show two years on the same chart, but I can't seem to find a dateformat that convert my variable "Date of Enrollment (format=DDMMYYYY) to just days and month. Therefore the chart looks like the one underneath here. Can anyone help me on this? Or maybe there is another clever way?

Problem 2:

Secondly I need to make a similar chart on the same data, but restricted to the last 10 days og June and the first 7 days of July. Is that possible to achieve with a conditionally expression (if yes, How?). 

I hope someone can help me

Thanks a lot

Cheers

Bruno

[Anonymous]

Hi,

  it is possible to provide test data .

Regards

[#3]

Yes

Here you go

Thanks

Bruno

[Gysbert_Wassenaar]

See attached qvw.

[Gabriel]

Hi,

Problem 1:

Convert date to day number :-

=Day(DATE)

= Month(DATE)

Problem 2:

Expert might be able to help

Let me know if Problem 1 is solved.

Regards,

Gabriel

[#6]

Hi Gysbert

Thanks for the answer and sorry for the late reply. Took monday off after Superbowl

I'm still having some problems though. I also want to accumulate data in the chart that's just showing a particular timeperiode but if I thick off the "Full accumulation" in the second chart you've made, it starts accumulating at 0.

If this is hard to change in QV its possible for me to maniputate my rawdata instead (I'm using SAS to "wash" my data before it's shown in a BI-system). However if there is an easy way to do it in QV its preferred

And another problem I came across. I have a selection making it possible to choose a single education (for example "Biology" or "Construction Engineering"). However if there is only one application within the chosen timeperiod I only get a dot, even though I've thicked of "Full accumulation" (see chart underneath). How can I get it to draw a straight line between the first and the last date at the chart?

Thanks in advance

Cheers Bruno

[#7]

Hi all

Thanks for your replies, but I'm still having some problems though. I also want to accumulate data in the chart that's just showing a particular timeperiode but if I thick off the "Full accumulation" in the second chart you've made, it starts accumulating at 0.

If this is hard to change in QV its possible for me to maniputate my rawdata instead (I'm using SAS to "wash" my data before it's shown in a BI-system). However if there is an easy way to do it in QV its preferred

And another problem I came across. I have a selection making it possible to choose a single education (for example "Biology" or "Construction Engineering"). However if there is only one application within the chosen timeperiod I only get a dot, even though I've thicked of "Full accumulation" (see chart underneath). How can I get it to draw a straight line between the first and the last date at the chart?

Thanks in advance

Cheers Bruno