Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
Showing results for 
Search instead for 
Did you mean: 
Contributor III
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

Hi, try this:

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

Master III
Master III

May be this -

if(GetSelectedCount([Fiscal - Year]),

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