As per calender week

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

Hi all,

Addition to this

below link I got the week count as per db.

My current requirement is : I have week column coming from db. so I want to get the count of current week like week(today()) that is 36. and if the data is not available for current week it should show "0"

Example1:

weekNumber

36 ---10records

35 ---5 records

output:

current week as per calendar is 36 --- so it will give 10

last week as per calendar is 35 ----it will give 5

Example1:

weekNumber

36 ---10records

34 ---5 records

current week as per calendar is 36 --- so it will give 10

last week as per calendar is 35 so here 34 only there so it will give "0" as output.

Re: Need Week count

Re: As per calender week

Anil_Babu_Samineni — Thu, 07 Sep 2017 10:09:15 GMT

You can manipulate in script like

Load ...., If(Week<> Week(Today()), '0', Week(Today())) from DB;

topic Re: As per calender week in QlikView

As per calender week

Re: As per calender week