Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist 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

1 Reply
Highlighted

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)