topic Re: Variable syntax in QlikView

Variable syntax

Wed, 19 Feb 2014 16:10:24 GMT

I have the following variable definition, but qlikview does not seem to like the syntax (the red squiggly underline starts with the first bracket). 'PeriodID' is previously defined, so I am not sure what qlikview does not like about this. The variable name is vSetYTD and the definition follows:

PeriodID = {"<=$(=Max(PeriodID))"},

Year = {$(=Max(Year))},

Quarter = ,

Month = ,

Period =

Re: Variable syntax

swuehl — Wed, 19 Feb 2014 16:22:18 GMT

Might be just a problem with the syntax checker, since your definition is not a valid expression (and as far as understood, it's not supposed to be one, it's just the short cut for some set expression content snippet, right? So you want to use something like

=sum({<$(vSetYTD), Type = {'A'}>} Value)

)

Re: Variable syntax

santharubban — Wed, 19 Feb 2014 16:27:30 GMT

Try this

=sum({<PeriodID ={$(vSetYTD)}>} Value)

Re: Variable syntax

Wed, 19 Feb 2014 16:29:06 GMT

It is setting vSetYTD (Year To Date) as a Set for Set Analysis against the same period for the previous year (which will be defined as vSetLYYTD (Last Year Year to Date). The data to be compared can be changed. This variable is just to set the base period for comparison.

Re: Variable syntax

swuehl — Wed, 19 Feb 2014 16:35:17 GMT

Understood, my point is that the syntax checker often claims something as 'wrong' which in fact is not (seen in full context).

Re: Variable syntax

Wed, 19 Feb 2014 16:50:21 GMT

Ok. Thanks. Here's hoping it works! LOL!