Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
davinfrost
Contributor III
Contributor III

how to show selected year

hello,

i want to ask, how to show selected years, because i wanted to show 2020,2019,and 2018

 

Untitled.jpg

 sum(
{<
FLAG_DB={'1'},
Year={'$(=max(Year))'}
>}
AMOUNT)

 

can i use 2 "Year" in 1 condition? for example Year={'$(=max(Year)),Year={'$(=max(Year)-1)'}  ??

if yes, how to?

 

thanks

2 Solutions

Accepted Solutions
tresesco
MVP
MVP

You can with a bit modification, like:

Year={'$(=max(Year))', '$(=max(Year)-1)' } 

View solution in original post

Vegar
MVP
MVP

I might be missunderstanding you, but your header is "how to show selected year".

If you want an expression to reflect your selection you don't need to create a modifier for the Year dimension.

Your can try to do like this. 

=sum({<FLAG_DB={'1'}>}AMOUNT)

View solution in original post

2 Replies
tresesco
MVP
MVP

You can with a bit modification, like:

Year={'$(=max(Year))', '$(=max(Year)-1)' } 

Vegar
MVP
MVP

I might be missunderstanding you, but your header is "how to show selected year".

If you want an expression to reflect your selection you don't need to create a modifier for the Year dimension.

Your can try to do like this. 

=sum({<FLAG_DB={'1'}>}AMOUNT)