How to add Set Analysis to this field in my expression?

[jblomqvist]

Hello there!

I have the following expression:

sum({<CREATE_DT={"$(= '>=' & '$(vFromDate)' & '<=' & '$(vToDate)' )"},TO_CURRENCY={$(vCurReport)}>}  ACCOUNT_SETTLEMENT*FIX_RATE)

I would like the FIX_RATE to be filtered on a variable of vDate. Any idea how I can specify this after the * in my expression above? For example it should be something like:

sum({<CREATE_DT={"$(= '>=' & '$(vFromDate)' & '<=' & '$(vToDate)' )"},TO_CURRENCY={$(vCurReport)}>}  ACCOUNT_SETTLEMENT* {$<$(vDate)>}FIX_RATE)

How can I do something like this please?

[Oleg_Troyansky]

Hi John,

Set analysis expression belongs to the whole aggregation, not to an individual field. Therefore, all filters need to be specified within the same set analysis expression. You already have one filter for the field CREATE_DT. If you have another date field that you need to limit by vDate, you can add another filter within the same Set Analysis modifier. All these filters apply to both operands in your calculation.

cheers,

Oleg Troyansky

Learn Set Analysis with me at the Masters Summit for QlikView!