Line charts - Variable reference line & filters

sguerra2 — Mon, 20 Dec 2021 21:08:46 GMT

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:

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

Re: Line charts - Variable reference line & filters

sunny_talwar — Thu, 15 Oct 2020 15:13:47 GMT

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

topic Line charts - Variable reference line & filters in App Development

Line charts - Variable reference line & filters

Re: Line charts - Variable reference line & filters