Using a variable in Set Analysis

[mhumphreys]

I am using Qlik Sense - June 2018 Version.

I am trying to retrieve the values from a set period of time (in this case quarters).  I am able to do this using this formula:

sum( {$<MonthNum = {'>0<4'}>} [QTY Shipped LB] )

which works quite well.  However I want to get creative and have been using variables on a straight table so that they mimic the "alternative measures" found in graphing.  I am able to pick a unit of measure (Lbs, $, Margin) from a variable extension I have simply by clicking on a button.

My problem is I have a variable called "vMeasure", but no matter how I either change the Set Analysis or try and use it in other formulas nothing appears to work.

Any help you can give would be appreciated.  Or a point in the right direction.  I have searched all over but could never find what I need.

[Jesh19]

Just try sum(vMeasure)

[mhumphreys]

I spoke too early.  It is almost there, however the selection of the months Jan-Mar is not working, but I think you put me on the right track.

[mhumphreys]

Jeshwanth - doesn't work at all.

[mhumphreys]

Thanks again Jonathan.  I was able to find what I needed thanks to your formula.  Here is the final result.

sum({$<MonthNum={$(='1,2,3')}>} Aggr($(vMeasure), [Core Business Description],Month  ))

This gives me Quarter 1 sales based on whatever button is pressed ($, LBS, or Margin).

Thanks to everybody that helped.

[jonathandienst]

Glad to help. You can probably simplify the set expression slightly

sum({$<MonthNum={1,2,3}>} Aggr($(vMeasure), [Core Business Description],Month  ))