Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

krishna4bo
Contributor

Dynamic financial year in set analysis

Hi All,

I have following expression here I want to take dynamic financial year(In Set expression) as per user selected '2016-2017' and  '2017-2018' how to achive this.

Thanks,

Krishna

1 Reply
jaumecf23
Contributor III

Re: Dynamic financial year in set analysis

Hi,

Try this : sum({<Year={">=$(=max(Year)-1) <= $(=max(Year))"}>}Amount)

Community Browser