Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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.

View solution in original post

MarcoARaymundo
Creator III
Creator III

Hi!

Look at the attached file.

Hope that helps you.

Marco

Not applicable

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

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

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

thank you