topic Re: Year Filter should not apply to my line chart in App Development

Year Filter should not apply to my line chart

sharu055 — Thu, 31 Mar 2022 18:29:32 GMT

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

Re: Year Filter should not apply to my line chart

abhijitnalekar — Thu, 31 Mar 2022 19:31:28 GMT

Hi @sharu055 ,

You can exclude filed from the set expression as below.

Sum({<Year=>}Amount)

Assuming Year is your dimension name.

Re: Year Filter should not apply to my line chart

sharu055 — Thu, 31 Mar 2022 19:37:30 GMT

@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.

Re: Year Filter should not apply to my line chart

abhijitnalekar — Thu, 31 Mar 2022 19:39:19 GMT

what is the expression you have used in measure?

Re: Year Filter should not apply to my line chart

sharu055 — Thu, 31 Mar 2022 19:43:10 GMT

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.

Re: Year Filter should not apply to my line chart

abhijitnalekar — Thu, 31 Mar 2022 19:46:42 GMT

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.

Re: Year Filter should not apply to my line chart

sharu055 — Thu, 31 Mar 2022 19:49:44 GMT

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

Re: Year Filter should not apply to my line chart

abhijitnalekar — Thu, 31 Mar 2022 19:54:10 GMT

Ooh no, Not like that.

Is it possible to share the expression?

Re: Year Filter should not apply to my line chart

sharu055 — Thu, 31 Mar 2022 19:59:12 GMT

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.

Re: Year Filter should not apply to my line chart

abhijitnalekar — Thu, 31 Mar 2022 20:17:34 GMT

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

Re: Year Filter should not apply to my line chart

sharu055 — Thu, 31 Mar 2022 20:19:55 GMT

Okay, thank you so much.