topic Expression in chart in QlikView

Expression in chart

QSense — Mon, 02 Apr 2012 10:49:17 GMT

Hi,

I have an expression below.

=avg ({$<TipDetay= {'Hizmet noktası'} >}Availability)

But I want to show last six months value of above expression

Sum({<[Rapor Tarihi]={'>=$(=MonthStart(Max([Rapor Tarihi]), -5))<=$(=MonthEnd(Max([Rapor Tarihi])))'},[Arıza Rapor Yılı]=>} [Karşılanan Çağrı Oranı]) -->

İn this expression as I understood The field '[Karşılanan Çağrı Oranı] ' will be replaced by 'Availability' field.

But it doesnt work.

Sincerely regards,

Expression in chart

jagan — Mon, 02 Apr 2012 10:53:39 GMT

Hi,

You can use this expression for finding the last six months average

=avg ({$<[Rapor Tarihi]={'>=$(=MonthStart(Max([Rapor Tarihi]), -5))<=$(=MonthEnd(Max([Rapor Tarihi])))'}, TipDetay= {'Hizmet noktası'} >}Availability)

Hope this helps you.

Regards,

Jagan.

Expression in chart

QSense — Mon, 02 Apr 2012 11:11:37 GMT

It didnt work for six months

in attached file as you see 4 months value is shown

Expression in chart

jagan — Mon, 02 Apr 2012 11:18:20 GMT

Hi,

This expression works, check whether you have data for all the six months. If you have any month/year fields exclude the selection by using the YearFieldName=, MonthFieldName=. Try below expression

=avg ({$<YearFieldName=, MonthFieldName= [Rapor Tarihi]={'>=$(=MonthStart(Max([Rapor Tarihi]), -5))<=$(=MonthEnd(Max([Rapor Tarihi])))'}, TipDetay= {'Hizmet noktası'} >}Availability)

Regards.

Jagan.