Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gautik92
Valued Contributor 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
Honored Contributor III

Re: Year Selection

can you share the expression in bar chart?

gautik92
Valued Contributor III

Re: Year Selection

its simply Sum(Amount)

arulsettu
Honored Contributor III

Re: Year Selection

try this

Sum({1}Amount)


or

Sum({<year>} Amount)


gautik92
Valued Contributor III

Re: Year Selection

I tried that is not working

arulsettu
Honored Contributor III

Re: Year Selection

can you post the app

gautik92
Valued Contributor III

Re: Year Selection

I cannot post the app.

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

okolyug16
Contributor II

Re: Year Selection

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

gautik92
Valued Contributor III

Re: Year Selection

this dint work already tried

chooco_co
Valued Contributor

Re: Year Selection

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