Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Expression not working in v9 sr7 and beyond

Hello,

Has anyone encountered this?

The following expression works in v9 sr6 not in v9 sr7 through v10.

Thanks

If (MAX(Year) = Year(Today()),

(sum({$<FlagCurYTD = {1}>}  [Sales Amount])

-

sum({$<FlagLastYTD = {1}>}  [Sales Amount]))

/

sum({$<FlagLastYTD = {1}>}  [Sales Amount]),

(sum({$<Year = {$(=max(Year))}, Period {}>}  [Sales Amount])

-

sum({$<Year = {$(=max(Year)-1)}, Period {}>}  [Sales Amount]))

/

sum({$<Year = {$(=max(Year)-1)}, Period {}>}  [Sales Amount]))

1 Solution

Accepted Solutions
danielrozental
Honored Contributor II

Expression not working in v9 sr7 and beyond

What's this "Period {}"? shouldn't it be "Period="?

You should try figuring out what part of the formula isn't working.

1 Reply
danielrozental
Honored Contributor II

Expression not working in v9 sr7 and beyond

What's this "Period {}"? shouldn't it be "Period="?

You should try figuring out what part of the formula isn't working.

Community Browser