Hi All,
Im new to qliksense and i was wondering if you could help me create an expression that show the last years weekly sales based on the selection of the current week.
EX. i selected Week 24 of This year. The expression will show Last year of Week 24.
I have [Fiscal Week ID] as one of the lookup data. this years fiscal week id = 181.
I'm thinking of something like this which is equivalent to excel formula.
Sum of Net Sales = Fiscal week (variable) - 53
Thanks.
