Year Filter should not apply to my line chart

[sharu055]

I put year field into my Dimension of qlikview line chart, I dont want my year filter should apply to the line chart as i need to show all years treand in line chart only avoid year filter.

please help how to create my year dimension

[abhijitnalekar]

Hi @sharu055 ,

You can exclude filed from the set expression as below.

Sum({<Year=>}Amount)

Assuming Year is your dimension name.

[sharu055 · Accepted solution]

@abhijitnalekar Hi Abhijit,

Actually i am using line chart, with two dimension and one expression. First dimension is of Month and second dimension is of years. My year should show all the years ( 2022,2021,2020,2019) even if i select 2022 in year filter. Need the formula for dimension that year should show all years irrespective selection of year filter.

[abhijitnalekar]

what is the expression you have used in measure?

[sharu055]

Its a big expression that includes count, sum and many functions not valuating only perticular field value. So i need to do it in dimension only.. Can we use any Veriable expression in dimension like it should display all year. Even if i select single year.

[abhijitnalekar]

That you have to handle on measure only.

you cant exclude filters on the dimension. I am sure if you use the given expression you will get the desired output.

[sharu055]

So how to add this expression with my big expression, can i add it end like 0*Sum({<Year=>}Amount). Is it will work. 

[abhijitnalekar]

Ooh no, Not like that.

Is it possible to share the expression?

[sharu055]

I am sorry, unable to share expression as it in client server, basically we are counting some of the incidents and summing those. Not using the year field in expression. I thout to do alternate state but so many objects it wont work. I thought we can do it in dimension. 

[abhijitnalekar · Accepted solution]

Its ok.

but you have to handle it in the measure expression only.

below link will help you.

https://community.qlik.com/t5/New-to-Qlik-Sense/Excluding-Filters-in-the-expressions/td-p/1401541