Discussion board where members can get started with QlikView.
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?
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
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.....