topic Re: how to show selected year in QlikView

how to show selected year

davinfrost — Wed, 25 Nov 2020 16:16:04 GMT

hello,

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

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

tresB — Tue, 21 Jul 2020 05:31:23 GMT

You can with a bit modification, like:

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

Vegar — Tue, 21 Jul 2020 07:09:01 GMT

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)