topic Set Analysis Syntactical Gymnastics… (incrementing variable reference) in QlikView

Set Analysis Syntactical Gymnastics… (incrementing variable reference)

Tue, 03 Aug 2010 23:33:26 GMT

I'm getting pretty adept at this set analysis business, but I'm having an issue defining a particular set.

I have a variable called 'CmpYear'; I use this variable in my sets just fine: {'$(CmpYear)'}

What does the set look like for CmpYear + 1? I've tried several different things, not really having a lot of success.

Thanks a ton!

Set Analysis Syntactical Gymnastics… (incrementing variable reference)

johnw — Tue, 03 Aug 2010 23:57:03 GMT

This? Seems to work for a completely unrelated variable and data in the application I'm currently fiddling with.

{'$(=$(CmpYear)+1)'}

Set Analysis Syntactical Gymnastics… (incrementing variable reference)

Wed, 04 Aug 2010 00:04:25 GMT

Exactly the insanity I was looking for.

So-called 'dollar sign expansion', and the dollar sign convention in set analysis make me very, very confused. Plus, all the wacky braces, brackets, quotes, et all.

Set Analysis Syntactical Gymnastics… (incrementing variable reference)

johnw — Wed, 04 Aug 2010 00:20:46 GMT

Yeah, I'm not particularly happy with QlikView using $ to mean three separate things, particularly when they can all occur together in rather short expressions:

sum({$<Year={'$(=$(CmpYear)+1)'}>} Value)

At least we can remove the first $ from the expression above since it's the default. I always do so to try to reduce some of the $ confusion. But the two remaining $ can still be confusing enough. And it's not like set analysis syntax needed any help being confusing.