Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Using MonthName with Set Analysis

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!!!

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Using MonthName with Set Analysis

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

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


2 Replies
Not applicable

Using MonthName with Set Analysis

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

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


Not applicable

Using MonthName with Set Analysis

Thanks ninja NMiller!

Community Browser