i have a little problem to select two different dynamic values from a field.
I solved with
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.
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.
Thank you all for your answer.
The correct answer is ='(' & max(ID_PERIOD)-100 & '|' & max(ID_PERIOD)& ')'
Retrieving data ...