Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

YTD View

Hi, all,

I'm trying to generate a YTD view on a certain metric, but the coding that I am using isn't working for some reason. I can't spot any syntax errors...

The code structure that I have been playing with is as follows:

(sum({<Month_Start={">=$(=Date(addmonths(Max(Month_Start), -(Num(Month)-1)), 'MMM-YYYY' ))<=$(=Date(addmonths(Max(Month_Start),0), 'MMM-YYYY')) "}>} [FIELD NAME])

Help???

1 Solution

Accepted Solutions
Luminary
Luminary

Re: YTD View

I think the formula would be a little easier it is was something like below:

sum({<Month_Start={"<=$(=Max(Month_Start)) "},Year={$(=max(Year))}>} [FIELD NAME])

Karl

1 Reply
Luminary
Luminary

Re: YTD View

I think the formula would be a little easier it is was something like below:

sum({<Month_Start={"<=$(=Max(Month_Start)) "},Year={$(=max(Year))}>} [FIELD NAME])

Karl