topic Expresion in Set Analysis in QlikView

Expresion in Set Analysis

Tue, 13 Oct 2009 02:12:15 GMT

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?

Expresion in Set Analysis

Anonymous — Tue, 13 Oct 2009 09:37:22 GMT

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.

Expresion in Set Analysis

Tue, 13 Oct 2009 16:08:16 GMT

try this

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

Expresion in Set Analysis

Tue, 13 Oct 2009 17:40:43 GMT

Thanks to both...

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