Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

2 control points in a formula

Sum({$<Year={$(=Max(Year-1))},FiscalYear={*}>}  Sales / $(vCurrency))

here is the formula for last year sales.

how would you change the formula where you would have sepereta control points for volume sales and currencies?

current situation:     sum( 'selected year' sales / currency )

I am looking for :  sum ('selected year' sales / 'selected different year' currency ) solution on above formula.

4 Replies
tresesco
MVP
MVP

Can you explain your 'selected different year' a bit more? Is it coming from another selection (may be using alternate state)?

Not applicable
Author

so on top I created options to select Fiscal Year drop down where you can select from 2012 to 2015.  I would like to be able to manipulate the expression where I can select 2015 which would give me 2015 sales but also be able to (hard code option is OK too) to select 2016 for currency data.  in other words - take last year sales with this year currency values.

tresesco
MVP
MVP

Explanation with a sample data set and expected output would be helpful.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Sum({$<Year={$(=Max(Year))},FiscalYear={*}>}  Sales /Only({<Year={$(=Max(Year+1))},FiscalYear={*}>} Currency)


Hope this helps you.


Regards,

Jagan.