Using 'Select in field' action for multiple selections - Dynamic

[a_travino]

Hello,

i have a little problem to select two different dynamic values from a field.

I solved with

(201510|201610)

but i want select

(max(ID_PERIOD) - 100|max(ID_PERIOD))

I would select the year-month current with the previous year for the same month.

Thanks!

[vinieme12]

use variables

vPeriod1 = max(ID_Period) - 100

vPeriod2 = max(ID_Period)

Select in  Field

='('& chr(34) & vPeriod1 & chr(34) & ' | ' & chr(34) & vPeriod2 & chr(34) & ')'

[vinieme12]

if your Query is resolved please close the thread

Qlik Community Tip: Marking Replies as Correct or Helpful

[marcus_sommer]

I think you could use $-sign expansion like:

($(=max(ID_PERIOD) - 100)|$(=max(ID_PERIOD)))

For more see here: The Magic of Dollar Expansions.

- Marcus

[a_travino · Accepted solution]

Thank you all for your answer.

The correct answer is ='(' & max(ID_PERIOD)-100 & '|' & max(ID_PERIOD)& ')'