Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

Need Current Selection - 1

Hi, I need an expression to take the current selection and minus one. For example, if Fiscal Year 2018 is selected, I need the expression to automatically - 1 to 2017. If 2016 is selected it would show 2015 etc.

if(GetCurrentSelections([Fiscal - Year]),

Sum({$<[Fiscal - Year]=GetCurrentSelections([Fiscal - Year]-1)>}

[Amount - Shipped/Fulfilled USD]),

This is what I tried, but its not working. Any assistance would be great

2 Replies
Contributor III

Re: Need Current Selection - 1

Hi, try this:

Sum({<[Fiscal - Year]={$(=Max([Fiscal - Year])-1)}>}[Amount - Shipped/Fulfilled USD])

Honored Contributor III

Re: Need Current Selection - 1

May be this -

if(GetSelectedCount([Fiscal - Year]),

Sum({$<[Fiscal - Year]={$(=Max([Fiscal - Year])-1)}>}[Amount - Shipped/Fulfilled USD]))

Community Browser