topic Re: Current Week-4 in QlikView

Current Week-4

Fri, 31 Jan 2014 14:30:57 GMT

I need a week,which will be current week minus 4 week.How to achieve this in UI.

Ex:My Current Week: 2013 W05

Expected Week is:(Current week-4) ie) 2013W01.

How to achieve this.Please help me.

Thanks,

Gowthami

Re: Current Week-4

MK_QSL — Fri, 31 Jan 2014 14:36:24 GMT

=Max(Week)-4

You can use as

SUM({$<Week = {"$(=Max(Week))"}>}Sales) // Max Week from selected weeks

SUM({$<Week = {"$(=Max(Week)-4)"}>}Sales) // Max Week - 4 from selected weeks

Re: Current Week-4

Fri, 31 Jan 2014 14:36:53 GMT

Hi Gowthami

Why can't you just subtract 4*7 from your date?

Lukasz

Re: Current Week-4

Gysbert_Wassenaar — Fri, 31 Jan 2014 14:50:23 GMT

If you calculate your weeks from a date field I suggest you create it as a dual field:

load

FieldA, FieldB, ...etc ,

MyDate,

dual( Year(MyDate) & 'W' & num(week(MyDate),'00') , weekstart(MyDate)) as MyWeek

From ...etc;

This way the MyWeek values will really still be dates (just shown like 2013W05) and you can subtract a number of days from it:

Expected Week = Current Week - 28

Current Week: max(MyWeek)

Expected Week: max(MyWeek)-28

Perhaps you need to use the weekyear function instead of the year function. Look the weekyear function up in the help file to understand why.

Re: Current Week-4

Fri, 31 Jan 2014 14:53:08 GMT

Hi ,

Thanks for your reply.

I have an inputbox, with two fields."Week1" and "Week2"

By default my

"Week 2" should be my Current week.

"Week1" should be current week minus 4

Week field is like this:

2013 W05

2013W04

2013W03

Max(week-4) is not working...

Thanks

Gowthami

Re: Current Week-4

ThornOfCrowns — Fri, 31 Jan 2014 15:13:29 GMT

Make sure you have your brackets right, Max(Week)-4 =/= Max(Week-4)

Re: Current Week-4

giakoum — Fri, 31 Jan 2014 15:17:26 GMT

Max(Week)-4 will never work this way. Imagine week being 2014W01. What would be Max(Week)-4? Go with Gysbert's suggestion (again )...

Re: Current Week-4

Fri, 31 Jan 2014 16:12:08 GMT

Hi,

Thanks for you reply.I don't have any date fileld in my QVD.

Thanks,

Gowthami

Re: Current Week-4

giakoum — Fri, 31 Jan 2014 16:14:37 GMT

then you maybe should create one using the week information. This will be helpful further on as well in your development.

Re: Current Week-4

Gysbert_Wassenaar — Fri, 31 Jan 2014 16:38:09 GMT

You could ask the person that created that qvd to put a date field in. That week field was created somewhere and most likely from a date field. Or ask him/her to create a dual field like I mentioned. Or ask him/her to at least add a numeric sequential week field so you have a field that can used in calculations to derive an earlier week.

Re: Current Week-4

santharubban — Fri, 31 Jan 2014 16:43:35 GMT

Gowthami

try this

weekname(WeekStart(date(WeekName(Today())-24)))

weekname(date(WeekName(Today())-24))

Re: Current Week-4

ashwanin — Fri, 31 Jan 2014 18:58:09 GMT

Hi Gowathami,

In your input box, how 2014 WK4 is coming?

Is it by some calculation or direct from QVD/File?

Also create new button and check is this formula working in this or not : =Week(today())-1