Line charts - Variable reference line & filters

[sguerra2]

Hi team,

Hope you are doing great! I am writing here because we have 2 doubts with Qliksense, hope you can help us!

1- Line chart : This is how we have it now... we have 3 countries in our Data, AR, CL & UY and we would like to add a reference line that contains the evolution of LAS (the 3 countries) (like in the excel chart below)

The formula used for calculation is: count({<[Base iCall-1.Estado]={'Enviada'}>}[Base iCall-1.Reunión remota: Nombre de reunión remota])/[Días]/count(distinct [Base iCall-1.Visita: Nombre del propietario])

Excel chart:

I know there is an option to add reference lines... I was able to add this line with a formula, but the issue is that  the reference should have different results per month, like in the screenshot above.  Is that possible????

2-Filters:

 I am trying to apply an automatic filter in the calculation of a graph but I have not got the correct result. My data table is as follows:

User	Team	Month	Sales
User 1	A	Jun	10
User 1	A	May	12
User 1	A	Apr	13
User 2	A	Jun	20
User 2	A	May	25
User 2	A	Apr	27
User 3	B	Jun	30
User 3	B	May	33
User 3	B	Apr	31

If a filter in the model User 1, i need a chart to show me the results of the user's Team that has been filtered, not just that user or the rest of the teams. In this case the result of Team A:

Thanks in advance!!

Sofía

[sguerra2]

User	Team	Month	Sales
User 1	A	Jun	10
User 1	A	May	12
User 1	A	Apr	13
User 2	A	Jun	20
User 2	A	May	25
User 2	A	Apr	27
User 3	B	Jun	30
User 3	B	May	33
User 3	B	Apr	31

If a filter in the model User 1, i need a chart to show me the results of the user's Team that has been filtered, not just that user or the rest of the teams. In this case the result of Team A:

[sunny_talwar · Accepted solution]

@sguerra2 point 2 is answered here -> https://community.qlik.com/t5/Qlik-Sense-App-Development/Graphics-filter/td-p/1752885