Expresion in Set Analysis

[#1]

I use Set Analysis:

=SUM ({$<PERIODE={'Oct 2009'}>} SALES)

But, I want to select using a expression like this:

=SUM ({$<PERIODE={MONTHNAME(TODAY())}>} SALES)

Error in set modifier ad hoc element list... What's wrong?

[Anonymous]

Hi,

I don't have QlikView in front of me at the moment but you would need to use the dollar sign expansion to evaluate the monthname function.

=SUM ({$<PERIODE={$(=MONTHNAME(TODAY()))}>} SALES)

Now, if I remember correctly the Monthname() will return 'oct 2009' instead of 'Oct 2009'. Can't remember if this is an issue when matching values in Set Analysis though. In that case you would have to use Capitalize() around the Monthname function to get it to return 'Oct 2009' as in the first example.

[#3]

try this

= SUM ({1<PERIODE={"$(MONTHNAME(TODAY()))"}>} SALES)

[#4 · Accepted solution]

Thanks to both...

I use a mix: SUM ({1<PERIODE={"$(=MONTHNAME(TODAY()))"}>} SALES)