topic Re: Chart using week as Dimension and shows current and previous week's data in QlikView

Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 02:44:13 GMT

Hi I am trying to find out if this is possible.

WeekStart	Count1	Previous Week	Count2
1/1/2012	10	12/25/2011	3
1/8/2012	15	1/1/2012	10
1/15/2012	21	1/8/2012	15
1/22/2012	5	1/15/2012	21
1/29/2012	3	1/22/2012	5
2/5/2012	11	1/29/2012	3

I have tried as following

Dimension: WeekStart

Count1 :

=sum(Count)

Previous Week:

=WeekStart(WeekStart, -1, -1)

Count2:

=sum({$<WeekStart={$(=WeekStart(WeekStart, -1, -1))}>} Count) // -> not working as is

Do you know if above table is possible?

Thanks,

Sean

Re: Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 04:59:08 GMT

Hi Nouckduri,

Try This Expression

=SUM({$<WeekStart={$(=max(WeekStart),-1)}>}Count)

Regards,

Nirmal.

Re: Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 05:12:25 GMT

Hi Nirmal,

I have tried it, but seems not working...

=SUM({$<WeekStart={$(=max(WeekStart)-1)}>}Count)

Re: Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 05:15:59 GMT

in between (weekstart) and -1 please asign comma(,)

Re: Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 05:19:30 GMT

I have tried both.

Re: Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 05:20:10 GMT

what's the error it shows

Re: Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 05:30:06 GMT

I have attached my file.

It gives me 0.

Re: Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 05:31:37 GMT

i think error in script....can you share your app with me

Re: Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 05:38:18 GMT

i have added it in my original post.

Re: Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 07:03:14 GMT

Try using above function. in the first column calculate Week's Sales.

In next use expression like =Above(column(1)) then if you are interested in only difference you can just hide these columns in presentation.

Regards

Re: Chart using week as Dimension and shows current and previous week's data

Sat, 03 Nov 2012 13:46:38 GMT

Thanks,

I have modified the expression to

= if( RowNo() = 1, 0, Above(column(1)))