Discussion board where members can get started with Qlik Sense.
my monthy target is 85.
I'll wish create a dynamic target.
Formula is: month * 85
01 (January) * 85 = 85
02 (February) * 85 = 170
03 (March) * 85 = 255
Perhaps I need to convert 01 to number and then *85
But which is the instruction?
May be like this:
LOAD Num(Month(Date)) * 85 as Target