Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current Week Selection from old dates

Hello Everyone,

I am new to QlikView, I have a task where I have a field named as Last Invoiced as below

                                      qli.png

my task is to 'Show the list of customer list who's invoice date is in current week'

then how I explore the current week date from the given old date. please  help me out.

Thank you.

16 Replies
its_anandrjs

Ok then you have to try this in any list box expression

=if(Week([Last Invoiced]) = week(Today()), [Last Invoiced])

Or

=if(Week([Last Invoiced]) = week(Today()), Date([Last Invoiced]) &'_'& Week([Last Invoiced]))

But bu this you get data for all years but only for current week that is week 20, and if you get more data then select year value in the list box.

MarcoARaymundo
Creator III
Creator III

Hi!

Look at the attached file.

Hope that helps you.

Marco

Not applicable
Author

This app file is different from my qlikview personal edition show the s/w is not open it,please write the script of the file here..

MarcoARaymundo
Creator III
Creator III

DATA:

LOAD * INLINE [

  INVOICE_ID, INVOICE_DATE, CLIENT_ID, INVOICE_VALUE

  1,2014/05/12,100,150

  1,2014/05/01,100,333

  2,2014/05/14,111,250

  4,2014/05/13,115,525

];

INVOICE:

LOAD

  WeekName(INVOICE_DATE) AS WEEK_KEY,

  INVOICE_ID,

  INVOICE_DATE,

  WeekName(INVOICE_DATE) AS WEEKMONTH,

  CLIENT_ID,

  INVOICE_VALUE

RESIDENT DATA;

DROP TABLE DATA;

CALENDAR:

LOAD

  WeekName(MakeDate(2014,5,RecNo())) as WEEK_KEY,

  Year(MakeDate(2014,5,RecNo())) as YEAR,

  Month(MakeDate(2014,5,RecNo())) as MONTH,

  Day(MakeDate(2014,5,RecNo())) as DAY,

  WeekName(MakeDate(2014,5,RecNo())) as WEEK

AUTOGENERATE 31;

Not applicable
Author

sorry but it does not result the requirement..

MarcoARaymundo
Creator III
Creator III

bhavi2803


from what I understand your need ... for me is working.

Put an example so I can understand what you need.

Not applicable
Author

Thank you everyone for replying,my requirement is done as above explained by anand chauhan with some modification.

thank you