topic Re: 2 control points in a formula in QlikView

2 control points in a formula

Wed, 17 Feb 2016 14:15:34 GMT

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.

Re: 2 control points in a formula

tresB — Thu, 18 Feb 2016 07:29:38 GMT

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

Re: 2 control points in a formula

Thu, 18 Feb 2016 13:45:03 GMT

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.

Re: 2 control points in a formula

tresB — Fri, 19 Feb 2016 04:58:38 GMT

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

Re: 2 control points in a formula

jagan — Fri, 19 Feb 2016 05:32:21 GMT

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.