topic Using MonthName with Set Analysis in QlikView

Using MonthName with Set Analysis

Mon, 04 Jan 2010 23:20:15 GMT

Hi, my problem is:

I select a field PeriodEstimate with value Nov 2009.
I've a text with: MONTHNAME(PeriodEstimate-1) and the value is Oct 2009.

Then, I try to use it in a set analysis:

If I write:
=AVG({$< PeriodEstimate ={'Oct 2009'}>} [Result]) works fine.

But, If I write:
=AVG({$< PeriodEstimate ={'MONTHNAME(PeriodEstimate-1)'}>} [Result]) the result is null.

Can you help me? Thanks!!!

Tue, 05 Jan 2010 00:51:56 GMT

I think you need a dollar sign expansion for the Monthname expression:

=AVG({$< PeriodEstimate =
{'$(=MONTHNAME(PeriodEstimate-1))'}>} [Result])

Tue, 05 Jan 2010 01:15:17 GMT

Thanks ninja NMiller!