Discussion board where members can get started with QlikView.
I need to show data for the past 12 months of the current date (including current month)
Currently, my dimension for my chart is a calculated dimension:
How do I only show the past 12 months?
Solved! Go to Solution.
This can be done using set analysis
Example if ur date field is rcptdate and ur present expression is Sum(Sales)
If your requirement is based on the given date
vSelected date is a variable which has the date selected.
Where exactly do I put this? If I put it in expression, it tells me "No data to display"
and my current expression was:
Then, changing it using your tip:
And I get "no data can be displayed"
Actually, I think I found the first issue:
I change the Today() to Now() and that seemed to get data to come back
It is, however, still giving me all data back, and not the past 12 months