topic Re: WeekStart question in QlikView

WeekStart question

alexpanjhc — Thu, 25 Apr 2013 14:54:35 GMT

I have a file where it shows all the counts for the invoices everyday. I want to show them by a date ---that is every monday of the week ,

so I used weekstart(date) to show the week.

The issue is March 1 is a Friday, when I used weekstart(date), it will skip march 1st and the count will be less.

How to add march 1 back to my chart?

Thanks!

Re: WeekStart question

swuehl — Thu, 25 Apr 2013 16:54:16 GMT

Not sure if I understood correctly, I think Mar 1st will still be counted, but towards its February weekstart.

Can you maybe explain with some sample data lines how your input data looks like and how you want to display it?

Re: WeekStart question

alexpanjhc — Thu, 25 Apr 2013 17:14:47 GMT

Hi thaks for replying

The attached is the date file.

So if I start using weekdate, the march 1 does not show instead 2/25.

I do not want to see 2/25.

Actually for each month, they'd like to see the actual date not the forwading weekstart

Is this doable?

Thanks!

Re: WeekStart question

swuehl — Thu, 25 Apr 2013 17:36:13 GMT

Are you thinking of something like attached?

Try

=if(Month(weekstart(F1))=month(F1),Weekstart(F1))

as calculated dimension and suppress NULL on the dimension.

This will supress your week starting in February, but please note that your last week is also not a complete week, so comparing this week with the other, full 7 days weeks, is like comparing apples with oranges.

Re: WeekStart question

alexpanjhc — Thu, 25 Apr 2013 18:41:44 GMT

Thanks,

But I still need march 1 show on the chart.

Re: WeekStart question

swuehl — Thu, 25 Apr 2013 21:56:59 GMT

I'm still unsure what you want to show with this kind of chart, but try

=if(Month(weekstart(F1))=month(F1),Weekstart(F1), monthstart(F1) )