QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Contributor II

Expression error

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ı])

1 Solution

Accepted Solutions
Not applicable

Expression error

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

4 Replies
Not applicable

Expression error

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

Esteemed Contributor

use like below

hope this helps

Contributor II

Expression error

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

MVP

Expression error

Hi,

Try this

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

Celambarasan