topic Re: Comparing selected week to previous week in QlikView

Comparing selected week to previous week

Sun, 05 Oct 2014 06:25:29 GMT

Hi,

I have a date field (Salesweek) and few other KPI's. I created listbox for Salesweek and other table chart has KPI's.

When I select Salesweek 8/18/2014 in the list box and my table charts has to show NET KPI for that selected date and a week before data 8/11/2014.

Prod NET NETpreviousweek

LAPTOP $2000 $2500

Is this can be achieved by set expression?

Thanks,

Re: Comparing selected week to previous week

anbu1984 — Sun, 05 Oct 2014 06:43:38 GMT

Selected week: Sum({<Salesweek={$}>}Sales)

Week before: Sum({<Salesweek={$(=Date(Max(Salesweek)-7,'M/D/YYYY'))}>}Sales)

Re: Comparing selected week to previous week

Sun, 05 Oct 2014 06:54:51 GMT

Thanks for your quick reply, but its not working

Thanks,

Re: Comparing selected week to previous week

anbu1984 — Sun, 05 Oct 2014 07:01:31 GMT

Is Saleweek field has same value 8/18/2014 for entire week 8/11/2014 to 8/18/2014?
Can you show sample data?

Re: Comparing selected week to previous week

jyothish8807 — Sun, 05 Oct 2014 07:19:56 GMT

Hi Madhu,

Hope this helps.

Regards

Re: Comparing selected week to previous week

Sun, 05 Oct 2014 08:47:19 GMT

Its having week starting date like 7/28/2014, 8/4/2014, 8/11/2014,8/18/2014 like that...

Jyothish, I am using personal edition.

Thanks,

Re: Comparing selected week to previous week

jyothish8807 — Sun, 05 Oct 2014 09:42:27 GMT

Hi madhu,

create a variable:

Var=GetFieldSelections(Date)

exp1:

sum({<Date={"$(=Var)"}>}Amount)

Exp2:

sum({<Date={">=$(=Var)<=$(=Var)-7"}>}Amount)

In dimension:

Product

Rename the fields as per ur data.

Regards

Re: Comparing selected week to previous week

anbu1984 — Sun, 05 Oct 2014 11:23:37 GMT

Selected week: Sum(Sales)

EDIT:

Previous week: Sum(TOTAL {<Saleweek={"$(=Date(Max(Saleweek)-7,'M/D/YYYY'))"}>}Sales)

Re: Comparing selected week to previous week

Sun, 05 Oct 2014 13:49:32 GMT

I guess second expression needs some changes as it has to sum amount for previous week:

sum({<Date={"<=$(=Var)>=$(=Var)-7"}>}Amount)

But it still ignoring Var-7.

Thanks,

Re: Comparing selected week to previous week

anbu1984 — Sun, 05 Oct 2014 14:39:42 GMT

sum( TOTAL {<Saleweek={">=$(=Date($(=Var-7),'M/D/YYYY'))<$(=Var)"}>}Sales)

Re: Comparing selected week to previous week

jyothish8807 — Sun, 05 Oct 2014 15:01:26 GMT

Hi,

try this:

sum({<Date={">$(=Var)<$(=Var)-7"}>}Amount)

Regards