How to show week on week, on Line Chart

[#1]

Hi,

I've attached an example of what we did in our previous reporting tool ProClarity.

As you can see the other academic year's data are shown on the same time axis as the current year so you can compare week on week. On the Qlikview graph if you select the other years it has the affect of placing them in series rather than in parallel as on the ProClarity Graph.

Any ideas?

Many thanks

[#2]

I would like it to look like the following, attached.

[prieper · Accepted solution]

Not that easy with a text-string.
In any case you need to replace the dimension "DATE ...." with a calculated value like
"=NUM(MONTH(ENW_WeeklyTime.DAT), '00') & '-' & NUM(DAY(ENW_WeeklyTime.DAT), '00')"
and put the sorting by Text ascending.

HTH
Peter

[johnw]

This seems to work if you use numeric sorting:

=date(makedate(1+(month(ENW_WeeklyTime.DAT)>7),month(ENW_WeeklyTime.DAT),day(ENW_WeeklyTime.DAT)),'MM/DD')

So does this:

=dual(date(ENW_WeeklyTime.DAT,'MM/DD'),daynumberofyear(ENW_WeeklyTime.DAT,8))

But you'd be better off building a field like that in the script.

[#5]

Hi guys, I'm attempting to do this same thing. What does the .DAT mean in the variable? I havn't seen that used in qlikview before.

Thanks,

Alex