Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to calculate the data related years..?

Hi All,

I have one dashboard in that dasboard having many number of objects.All objects are related to current year data(2015).

But I want to display previous year data and next year data with in the dashboard means suppose i m click previous year(2014) all objects are display related year data and i m click next year(2016) all objects are display realated year data.

how to display the data corresponding years with in all objects in dashboard.? plz write the discussion in discussion window only.Plz don't touch the qvw files

any one plz tell me. its urgent

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Just remove the condition you wrote in the objects to display current year data

Example

Sum({<Year={'$(=Year(Today()))'}>} Sales) from this just remove "Year={'$(=Year(Today()))'}"

Sum(Sales)

Not applicable
Author

Hi

use this

Sum({<Year={'$(=Year(Today()))'}>} Sales)

or

Sum({<Year={'=getfiledselections(Year)'}>} Sales)