topic Set analysis and Dollar-Sign Expansion in QlikView

Set analysis and Dollar-Sign Expansion

Mon, 10 Aug 2009 22:45:20 GMT

Experts,

I am trying to get the latest month number for current selection using following expression:

=Sum({$<monthyear={$(=Max(monthyear))}>} amount)

but it returns NULL values.

Then I tested it using a string instead of Dollar-Sign Expansion. it does work

=Sum({$<monthyear={'Jun-2009'}>} amount)

The Format of 'monthyear' is MMM-YYYY

Does anyone know what is wrong with 1st expression and how to get it to work.

Many thanks

Set analysis and Dollar-Sign Expansion

Mon, 10 Aug 2009 22:50:31 GMT

try this:


=Sum({$<monthyear={'$(=Max(monthyear))'}>} amount)

note the little ' if you can't see it in the code. Conversely, you could make declare Max(MonthYear) a variable and the set analysis syntax would be less complicated??

Set analysis and Dollar-Sign Expansion

Mon, 10 Aug 2009 23:28:18 GMT

adding ' works. Using variable gives right results as well.

Thanks a lot for this