Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
soniasweety
Valued Contributor III

As per calender week

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

Tags (4)
1 Reply

Re: As per calender week

You can manipulate in script like

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)