topic Re: how to calculate the week? in QlikView

how to calculate the week?

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

Hi,

I have date filed and i am writing week(mydatefield).so i am getting the complete weeks entire year.

1233456789.....

my requirement is when i select feb i want show only fed weeks like1,2,3,4 weeks .

if i select jun again show only jun weeks starting 1,2,3, 4 like that.how to achieve this.

Thanks

chaitu

swuehl — Tue, 03 Apr 2018 18:08:09 GMT

In your master calendar, you can create the month based week counter like

LOAD

Date,

Week(Date) as Week,

Autonumber( Week(Date), MonthName(Date) ) as WeekInMonth,

Month(Date) as Month,

MonthName(Date) as MonthName,

...

uacg0009 — Wed, 04 Apr 2018 02:59:53 GMT

Hi krishna,

I have a question, if you select feb and jun at the same time, then what do you want to show?

Thanks.

Aiolos