Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

target

Hi Community,

my monthy target is 85.

I'll wish create a dynamic target.

Formula is: month * 85

Example:

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?

Fabio M

1 Reply
MVP
MVP

Re: target

May be like this:

LOAD Num(Month(Date)) * 85 as Target

FROM Source;

Community Browser