topic Comparing Sales data for different customers in same chart in App Development

Comparing Sales data for different customers in same chart

Anonymous — Thu, 08 Feb 2018 02:08:58 GMT

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?

Re: Comparing Sales data for different customers in same chart

wouterlely — Fri, 09 Feb 2018 11:56:33 GMT

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

Re: Comparing Sales data for different customers in same chart

Anonymous — Mon, 12 Feb 2018 01:28:37 GMT

Hey there, appreciate the links and example.

Will try them out!