Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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)