Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
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?

Labels (1)
2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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
Author

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.....