Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi!
Look at the attached file.
Hope that helps you.
Marco
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..
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;
sorry but it does not result the requirement..
from what I understand your need ... for me is working.
Put an example so I can understand what you need.
Thank you everyone for replying,my requirement is done as above explained by anand chauhan with some modification.
thank you