topic Re: prior week selections? in QlikView

prior week selections?

Anonymous — Tue, 06 Jan 2015 07:57:56 GMT

Hi,

i have chart like 'transaction' is the Dimension and Finding sum(sales) in this expression i have used week

here my req is

when i click on current week i want see the result for last week

when i select 3 week dates then i want see the result for prior to select last 3 weeks

in clear

for example

current week last week

1/3/2015 29/12/2014 - if he select current week then he need to see result for past week

if he select any 3 weeks at a time i want see result for past 3 weeks of selections

Re: prior week selections?

jagan — Tue, 06 Jan 2015 08:02:37 GMT

Hi,

Attach sample file so that it would be easier to provide solution.

Regards,

jagan.

Re: prior week selections?

mdmukramali — Tue, 06 Jan 2015 08:32:58 GMT

Dear ,

Kindly find the attached file.

as you mentioned if one Week is selected it will show the Previous week Total.

if you select 2 then it will show last 2 Previous Weeks Total and vice verse.

I hope it will help you.

Thanks

Mukram

Re: prior week selections?

Anonymous — Tue, 06 Jan 2015 18:25:14 GMT

hi when i click on any week i want see sales for prior to that week

for ex:

6/1/2014

13/1/2014

when i click on 13/1/2014 i want see for only 6/1/2014 it means for only that one

.(excluding selections weeks)

if i select 3 weeks then i want sales for past 3 weeks to prior to that weeks

like this if i select 4 weeks i want see four week sales for prior to selection weeks

Re: prior week selections?

jagan — Wed, 07 Jan 2015 02:14:54 GMT

Hi,

Try this expression

=Sum({<Week = ,WeekDate={'>=$(=WeekStart(Min(WeekDate), -GetSelectedCount(Week)))<=$(=WeekEnd(Min(WeekDate), -1))'}>} SoldAmt)

Hope this helps you.

Regards,

Jagan.

Re: prior week selections?

SunilChauhan — Wed, 07 Jan 2015 03:55:13 GMT

weekstart(date)-7

will give start of previous week and Date(date-7) will give date of previous week

Re: prior week selections?

mdmukramali — Wed, 07 Jan 2015 09:00:53 GMT

Dear,

did you check my attached sample file?

I think it's full filling your requirement

Thanks,

Mukram.