Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

WeekStart
Count1
Previous Week
Count2

1/1/2012

10

12/25/20113
1/8/2012151/1/201210
1/15/2012211/8/201215
1/22/201251/15/201221
1/29/201231/22/20125
2/5/2012111/29/20123

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

10 Replies
Not applicable
Author

Thanks,

I have modified the expression to

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