# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for
Did you mean:
Specialist II

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

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

1 Solution

Accepted Solutions
MVP

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

2 Replies
MVP

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

Specialist II
Author

Hi Sunny,

As always thanks for your prompt and useful response.

Thanks & Regards,

Vijay

Community Browser