Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
gautik92
Specialist III
Specialist III

Year Selection

I have a filter for year

and also I have a bar chart with year as dimension

i want year to be static in bar chart if i select in filter year in bar chart shud not change

16 Replies
arulsettu
Master III
Master III

can you share the expression in bar chart?

gautik92
Specialist III
Specialist III
Author

its simply Sum(Amount)

arulsettu
Master III
Master III

try this

Sum({1}Amount)


or

Sum({<year>} Amount)


gautik92
Specialist III
Specialist III
Author

I tried that is not working

arulsettu
Master III
Master III

can you post the app

gautik92
Specialist III
Specialist III
Author

I cannot post the app.

actually I want that bar chart to be static it shud not reflect when we click on year

Anonymous
Not applicable

try this Sum({<Year=>}Amount)

gautik92
Specialist III
Specialist III
Author

this dint work already tried

marcohadiyanto
Partner - Specialist
Partner - Specialist

Hi Gowtham

You can use set analysis to solve your issue

sum({<Year>}Amount)

Please check Year is the same field as your Year filter and it's case sensitive.

Regards