QlikView App Dev

[vvira1316]

Dimension

=MonthName([ReqDt])

Expression for Line Chart

=Count(
{<
[ReqDt]={'>=$(=vBegDateLast24thMonth)<=$(=vEndDateThisMonth)'},
[MDT]={'Val1', 'Val2'},
[SDT]={'Val3', 'Val4'}
>}
[ID])

Expression for Average Line Chart

=Round(Avg(TOTAL Aggr(Count(
{<
[ReqDt]={'>=$(=vBegDateLast24thMonth)<=$(=vEndDateThisMonth)'},
[MDT]={'Val1', 'Val2'},
[SDT]={'Val3', 'Val4'}
>}
[ID]), [ReqDt Date Year], [ReqDt DateMonth])))

Chart when no selection is made

Chart when some month selection is done from chart

This image is showing month selection

This image is showing resulting chart

I'm trying to understand why Average Line chart reflects selection where as the other chart is still showing the original chart. Though both expressions (Line and Average)  are using same set analysis criteria.

Let me know if any additional information is needed.

Any guidance will be helpful.

Thanks & Regards,

Vijay

[sunny_talwar · Accepted solution]

The second one isn't using the same criteria.... for them to use the same criteria, you need set analysis in the outer aggregation as well

=Round(Avg(TOTAL

{<
[ReqDt]={'>=$(=vBegDateLast24thMonth)<=$(=vEndDateThisMonth)'},
[MDT]={'Val1', 'Val2'},
[SDT]={'Val3', 'Val4'}
>}

Aggr(Count(
{<
[ReqDt]={'>=$(=vBegDateLast24thMonth)<=$(=vEndDateThisMonth)'},
[MDT]={'Val1', 'Val2'},
[SDT]={'Val3', 'Val4'}
>}
[ID]), [ReqDt Date Year], [ReqDt DateMonth])))

[vvira1316]

Hi Sunny,

As always thanks for your prompt and useful response.

Thanks & Regards,

Vijay