topic Expression error in QlikView

Expression error

QSense — Thu, 29 Mar 2012 08:45:12 GMT

Hi,

İn chart, I want to show last 6 months value as minichart in chart

My expression below.

I dont know what is wrong?

Sum({<[Rapor Tarihi] ={">=date(today()-240),[Arıza Rapor Yılı]="} >} [Karşılanan Çağrı Oranı])

Thu, 29 Mar 2012 11:36:52 GMT

Hi ,

try to use something like this

Sum({<[Rapor Tarihi] ={">=date(today()-240) <= date(today(),'DD/MM/YYYY' ) "} >} [Karşılanan Çağrı Oranı])

also you can take help from below code will help you for last six moths value

=Sum({<DateField={'>=$(=MonthStart(Max(DateField), -5))<=$(=MonthEnd(Max(DateField)))'}>} Sales)

Warm Regards,

Anant Debey

SunilChauhan — Thu, 29 Mar 2012 11:39:30 GMT

use like below

sum( {<date={">=$(addMonths(date,-6))<=date={>=$(addMonths(date,0))"} sales)

hope this helps

QSense — Mon, 02 Apr 2012 07:12:08 GMT

Thanks for replies,

But they didnt work

[Arıza Rapor Yılı] the field expression wiil not be affected by it

Waiting for new solution

CELAMBARASAN — Mon, 02 Apr 2012 07:17:18 GMT

Hi,

Try this

sum( {<[Rapor Tarihi]={">=$(addMonths(Today(),-6))<=$(Today())"},[Arıza Rapor Yılı]=>} [Karşılanan Çağrı Oranı])

Celambarasan