The ideal way is to have week number associated to your data model (date field). You'd only need Week as your dimension in the pivot and sum(sales) as your expression. Any reason this cannot be done?
By its nature,qlik automatically does that. Whatever the selection you make in your filters , those entire selections will be carry forward to your entire dashboards unless you overide them using set analysis and alternative states. Please be more specific about your requirement and let's hand together with community folks to get a solution'
