Error in small script ?

[#1]

Sum({$<$(vSetPreviousNMonth(0))>} [# Departures Performed])

I see an error after - second curly brace, ie }. What is the error ? This is taken from the book, qlikview 11 for developers.

Variable definition is -

PeriodID = {$(=Max(PeriodID) – $1)},

Year = ,

Quarter = ,

Month = ,

Period =

Book output -

My output -

[chiru_thota]

Can you add your QVW here ?

Mean while add one more expression as sum(1) and see are you getting all values for Carrier Group

[#3]

PeriodID = {$(=Max(PeriodID) - $1)},

Year = ,

Quarter = ,

Period = ,

Month =

I added this to my expression and seems to be working fine.

Start with changing the dimension. Did you get the carrier Group from Carrie Group qvd?

[#4]

The qvd is attached. Sum(1) gives me all zeros in all columns. What is the meaning of sum(1) ?

[chiru_thota · Accepted solution]

You have wrong character in your variable vSetPreviousNMonth and I have corrected it.It has some bad character as shown below

also mentioned the right expression below.

[#6]

Thank you very much !