topic Re: Error in small script ? in QlikView

Error in small script ?

Tue, 08 Apr 2014 00:07:45 GMT

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 — Tue, 08 Apr 2014 01:12:05 GMT

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

Tue, 08 Apr 2014 01:28:34 GMT

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?

Tue, 08 Apr 2014 01:33:43 GMT

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

chiru_thota — Tue, 08 Apr 2014 04:30:28 GMT

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.

Fri, 11 Apr 2014 23:29:54 GMT

Thank you very much !