Comparing Sales data for different customers in same chart

[Anonymous]

Good day!

My data looks something like this:

CustomerName	OrderNumber	SalesAmt	OrderDate	CustomerGroup
Alpha	1	1000	Jan 2017	Manufacturing
Alpha	2	2000	Jan 2018	Manufacturing
Omega	3	300	Jan 2017	Education
Omega	4	5000	Jan 2018	Education
Charlie	5	4000	Jan 2017	Food and Beverage

I would like to plot a line graph that allows my users to pick multiple customers, or different groups of customers in a line chart for the same period over 2 or more years.

Would anyone knows what is the best way to do this in SENSE?

[wouterlely · Accepted solution]

Hi Kian,

Can you take a look at the QVF file and let me know if this solution is what you are looking for? You can use set-analysis or your selections to set the date.

Regards Wouter

Perhaps the following Links can help you further;

https://qlikcommunity.qliktech.com/message/1219709‌

Why Comparative Analysis

Qlik Sense - Comparative Analysis using Alternate States - YouTube

[Anonymous]

Hey there, appreciate the links and example.

Will try them out!