topic Re: Using 'Select in field' action for multiple selections - Dynamic in QlikView

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

a_travino — Wed, 14 Dec 2016 17:00:58 GMT

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 — Wed, 14 Dec 2016 17:52:59 GMT

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 — Sun, 18 Dec 2016 14:35:47 GMT

if your Query is resolved please close the thread

marcus_sommer — Mon, 19 Dec 2016 09:41:36 GMT

I think you could use $-sign expansion like:

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

- Marcus

a_travino — Mon, 19 Dec 2016 10:54:50 GMT

Thank you all for your answer.

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