topic How to show week on week, on Line Chart in QlikView

How to show week on week, on Line Chart

Thu, 03 Mar 2011 16:38:50 GMT

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

How to show week on week, on Line Chart

Thu, 03 Mar 2011 16:40:33 GMT

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

How to show week on week, on Line Chart

prieper — Thu, 03 Mar 2011 17:27:24 GMT

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

How to show week on week, on Line Chart

johnw — Fri, 04 Mar 2011 00:50:58 GMT

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.

How to show week on week, on Line Chart

Thu, 01 Sep 2011 13:10:02 GMT

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