Discussion Board for collaboration related to QlikView App Development.
I'm trying to combine the last 2 numbers from the year with the first character of the season.
For example: W19, S19
I'm usising following code:
='W'&max(right(num( Year(AddMonths(Today(),-1)) ),2))
This works, but when I create a variable of it, the result is "-". Very strange because it's the same code as the expression.
My variable Seizoenscode :
The set analyses I want to use the variable:
Anyone who knows how I can fix this?
thanks in advance
View solution in original post