topic Re: Current Week vs last three week trail in QlikView

Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 05:18:36 GMT

HI All,

What would be the logic for Current week Vs Last three Week Trend..

thanks In advance..

Re: Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 05:47:25 GMT

Kindly revert

Re: Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 07:23:59 GMT

Kindly revert

Re: Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 07:48:26 GMT

hi All ,

i tried in this way...

max(week)

Max(week)-3

is not working kindly help

Re: Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 07:51:44 GMT

=Sum({ < week=, Week ={">=$(='$(vLast3Week)')<=$(='$(vMaxWeek)')"}>} [Outstanding Amount])

Re: Current Week vs last three week trail

ecolomer — Mon, 27 Apr 2015 07:54:55 GMT

Here you have an example with 3 month, for the week are similar

Saludos,

Re: Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 07:57:45 GMT

Hey Enrique, Month Wise Done.. But Facing issue with week wise

Re: Current Week vs last three week trail

ecolomer — Mon, 27 Apr 2015 07:59:57 GMT

Give me your QV file and expalin the requeriment please

Re: Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 08:01:57 GMT

Hi Enrique, here u can find scramble app.. what i want is Current Week Sales Vs Last 3 Week Sales.

let say my current week is 18 and last three week are w17, w16,w15 so in bar chart i want that trend.

Thanks

Re: Current Week vs last three week trail

ecolomer — Mon, 27 Apr 2015 08:06:28 GMT

In this example you don't have data for week

week are no valours

Re: Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 08:11:51 GMT

fyi

Re: Current Week vs last three week trail

ankitaag — Mon, 27 Apr 2015 08:23:16 GMT

Hi,

Please find the attached app

Re: Current Week vs last three week trail

ankitaag — Mon, 27 Apr 2015 08:24:32 GMT

Please go through the app..

This is exactly what you want

Thanks and Regards,

Ankita

Re: Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 08:51:09 GMT

Hey Ankita,

i tried but not working

Re: Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 08:51:57 GMT

Hey Enrique,

Waiting For your revert..

Thanks

Re: Current Week vs last three week trail

ankitaag — Mon, 27 Apr 2015 09:25:35 GMT

What is not working Abhay?

Tha application is working at my end.

Moreover, you don't have values in week for all the InvoiceDate.

Kindly create the week like WeekStart(Invoice Date) as Week

and in the frontend create a variable for vMinWeek = Max(Week)-21

and CuerrentWeek = max(Week)

In the chart expression write =sum({<Date={">=$(vMinWeek} <=$(vCurrentWeek)"}>}Sales)

Re: Current Week vs last three week trail

tresB — Mon, 27 Apr 2015 09:33:56 GMT

Your expression

Sum({ < [Invoice Year]=, Week ={">=$(='$(vLast3Week)')<=$(='$(vMaxWeek)')"}>} [Outstanding Amount])

seems working fine.

Isn't it? Only issue could be if you are selecting other time dimension members as well. You have to just include them too in the set expression like you did for [Invioce Year].

Re: Current Week vs last three week trail

abhaysingh — Mon, 27 Apr 2015 09:39:02 GMT

Good to see you after so long...

but when i m selecting month it should give me selected month current week vs last 3 week trend right? but unfortunately it is not giving..

thanks

Re: Current Week vs last three week trail

ankitaag — Mon, 27 Apr 2015 12:59:50 GMT

You need to clarify 1 thing, if you select a month and suppose that month has only 1 week..so you need the last 3 weeks of the previous month in comparision or not?

Re: Current Week vs last three week trail

ecolomer — Mon, 27 Apr 2015 14:06:29 GMT

Today Ivery busy

Tomorrow I canb have some time for that.

I'm sorry

Saludos,