Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
Showing results for 
Search instead for 
Did you mean: 
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
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
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.....