topic Re: Two line charts with set analysis are behaving differently when a selection is made on the chart in QlikView

Two line charts with set analysis are behaving differently when a selection is made on the chart

vvira1316 — Tue, 22 Aug 2017 15:31:44 GMT

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

Re: Two line charts with set analysis are behaving differently when a selection is made on the chart

sunny_talwar — Tue, 22 Aug 2017 15:34:28 GMT

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

Re: Two line charts with set analysis are behaving differently when a selection is made on the chart

vvira1316 — Tue, 22 Aug 2017 15:43:37 GMT

Hi Sunny,

As always thanks for your prompt and useful response.

Thanks & Regards,

Vijay