topic Re: Week Number Count in QlikView

Week Number Count

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hello Friends,

I do have one Date Field. In that, i want to show the week number in Text object.

I written, Count(Week(DateField))

Is that expression is correct?

Re: Week Number Count

MindaugasBacius — Tue, 12 Jul 2016 07:52:02 GMT

Simple use week(DateField).

To get the week number in the TextObject you need to select only single Date.

Re: Week Number Count

MindaugasBacius — Tue, 12 Jul 2016 07:53:21 GMT

Also suggest you reading this blog post:

Redefining the Week Numbers

Re: Week Number Count

Anil_Babu_Samineni — Tue, 12 Jul 2016 07:53:52 GMT

Thanks Sir,

If i have 2005 to 2016 and then it showing 12 * 52 == Value

If i am using this it will working

=Count(distinct week(DateField))

Thanks

Re: Week Number Count

MindaugasBacius — Tue, 12 Jul 2016 07:55:19 GMT

In this case you need the total number of weeks between two dates, am I correct?

Re: Week Number Count

MindaugasBacius — Tue, 12 Jul 2016 07:56:54 GMT

 = (max(DateField) - min(DateField)) / 7

This formula allows you to get the exact number of weeks between two dates.

Re: Week Number Count

Anil_Babu_Samineni — Tue, 12 Jul 2016 07:59:05 GMT

Ok, This scenario i have only one Date field. How to get that. Is my expression is correct?

Re: Week Number Count

MindaugasBacius — Tue, 12 Jul 2016 08:13:49 GMT

Use this one:

= (max(DateField) - min(DateField)) / 7

Instead of DateField use your Date field.

Re: Week Number Count

Anil_Babu_Samineni — Tue, 12 Jul 2016 08:24:58 GMT

So, i want to show the weeks which is

If i want to show the report that time i want to show upto last week with the key of Starting Date to Reporting date - 1

Something like that. This scenario how do we use that

Re: Week Number Count

dineshraj — Tue, 26 Jul 2016 11:52:14 GMT

Hi Mindaugas Bacius,

I need make 19/4/2007 this week as first week of the year.

How to get it?

Re: Week Number Count

Anil_Babu_Samineni — Tue, 26 Jul 2016 12:02:55 GMT

Helpful

I am expecting some thing like this

Count(Distinct WeekNumber)

Here, Week number is Num(Week(DateField)) -- Script Level

Got it Thank you

Re: Week Number Count

dineshraj — Tue, 26 Jul 2016 12:16:38 GMT

Hi Anil Babu,

I get that as 1st week but i need the successive as 2,3,4.