Average per month with a calculated dimension

[#1]

Hi all QV users,

I've encountered a problem in Qlikview.

I have constructed an ImR chart in Qlikview and used the following expression to calculate the average:

avg(TOTAL aggr(sum(johan),Month))

It works fine but now am I trying to do the same with a calculated dimension instead of Month, this is the dimension I have:

=date(monthstart(Notif_date),'MMM YY')

Does anyone know how I combine these to two? I want to somehow replace Month in the first expression with the calculated dimension above.

Thanks!

[#2]

To make it easier, why don't you add the function "=date(monthstart(Notif_date),'MMM YY')" into your script ?

This way you'll avoid to get a calculated dimension, and your results will be faster ?

Regards,

Sébastien

[#3]

Ok,

how do I add it into my script?

thanks

[spividori]

Hi,

In the script:

date(monthStart(Notif_date),'MMM YY') as MonthYear

Regards.

[#5]

Thanks!

It solved my problem.

Regards