Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

You can with a bit modification, like:

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

View solution in original post

Highlighted
Partner
Partner

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)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Highlighted
MVP
MVP

You can with a bit modification, like:

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

View solution in original post

Highlighted
Partner
Partner

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)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post