Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Dynamic Dimension showing previous weeks data

I have a chart that shows some data by week. I want the graph to show the week selected (by default the highest week) and the previous 5 weeks. is there a calculated dimension that can do this?

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

It's possible to use a calculated dimension, but set analysis expressions usually perform better. Perhaps one of these discussions helps:

Set analysis - show only last 12 weeks data

Set Analysis Last n Weeks


talk is cheap, supply exceeds demand
Highlighted
Not applicable

The first link is very useful but if I make a selection on my "week" list box then it only shows the current selection - I want the current selections show, and the previous n weeks.....