topic Current Week Selection from old dates in QlikView

Current Week Selection from old dates

Thu, 15 May 2014 16:58:08 GMT

Hello Everyone,

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

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.

Re: Current Week Selection from old dates

Thu, 15 May 2014 17:06:36 GMT

Try this Bhawna,

if(week(date) = week(today()), date, NULL)

Re: Current Week Selection from old dates

its_anandrjs — Thu, 15 May 2014 17:14:57 GMT

For a list box you can write like

=If( YourDateField >=WeekStart(Today()) and YourDateField <=WeekEnd(Today()),YourDateField)

Eg:-

=If( [Last Invoiced] >=WeekStart(Today()) and [Last Invoiced] <=WeekEnd(Today()),[Last Invoiced])

Re: Current Week Selection from old dates

Thu, 15 May 2014 17:18:57 GMT

Today() returned system date..

Re: Current Week Selection from old dates

Thu, 15 May 2014 17:22:08 GMT

Right, and using week(today()) will return the current week... I.e. 5/15/2014 is week 20. Any week(date) that also returns 20 will be in your list box.

Re: Current Week Selection from old dates

Thu, 15 May 2014 17:23:55 GMT

it doesnt work

Re: Current Week Selection from old dates

Thu, 15 May 2014 17:25:10 GMT

there is no such any week,all the dates before the month May I have checked..

Re: Current Week Selection from old dates

Thu, 15 May 2014 17:27:13 GMT

in the table only May month is not added,may be after the may month it will work

Re: Current Week Selection from old dates

its_anandrjs — Thu, 15 May 2014 17:34:37 GMT

You want to fetch invoice date is in current week but if you not have current week dates so how you get that for old dates it won't compare. The reply i give from that i get current week dates like From 5/12/2014 to 5/18/2014.

Re: Current Week Selection from old dates

Thu, 15 May 2014 17:41:34 GMT

That is my question,I have assigned this task,and told me to consider invoice date as today date,so I am not able understand how is this possible.

Re: Current Week Selection from old dates

its_anandrjs — Thu, 15 May 2014 17:52:15 GMT

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

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

=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.

Re: Current Week Selection from old dates

MarcoARaymundo — Thu, 15 May 2014 18:10:31 GMT

Hi!

Look at the attached file.

Hope that helps you.

Marco

Re: Current Week Selection from old dates

Thu, 15 May 2014 18:15:14 GMT

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..

Re: Re: Current Week Selection from old dates

MarcoARaymundo — Thu, 15 May 2014 18:25:22 GMT

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;

Re: Current Week Selection from old dates

Thu, 15 May 2014 18:31:23 GMT

sorry but it does not result the requirement..

Re: Current Week Selection from old dates

MarcoARaymundo — Thu, 15 May 2014 19:34:45 GMT

bhavi2803

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

Put an example so I can understand what you need.

Re: Re: Current Week Selection from old dates

Fri, 16 May 2014 07:46:36 GMT

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

thank you