Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)))