topic Getting Max() from Alternate States selection in QlikView

Getting Max() from Alternate States selection

Anonymous — Wed, 09 Jan 2013 15:29:26 GMT

Hi there,

I am using Max(Year) and Max(Year)-1 to get the year and the previous your from my selection.

Now I need the Max(Year) and the Max(Year)-1 from an Alternate State selection.

I need them in my expression. Any idea how this expression would look like?

Thank you all.

Dennis.

nagaiank — Wed, 09 Jan 2013 15:38:14 GMT

Did you try

Max( { [AlternateState] } Year)

Anonymous — Wed, 09 Jan 2013 15:48:05 GMT

Thanks that is it, I got lost in way to many < $:: > )( [ ] { }'s 🙂