Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Thank you all for your answer.
The correct answer is ='(' & max(ID_PERIOD)-100 & '|' & max(ID_PERIOD)& ')'
use variables
vPeriod1 = max(ID_Period) - 100
vPeriod2 = max(ID_Period)
Select in Field
='('& chr(34) & vPeriod1 & chr(34) & ' | ' & chr(34) & vPeriod2 & chr(34) & ')'
if your Query is resolved please close the thread
Qlik Community Tip: Marking Replies as Correct or Helpful
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
Thank you all for your answer.
The correct answer is ='(' & max(ID_PERIOD)-100 & '|' & max(ID_PERIOD)& ')'