Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

leekianteck
New Contributor

Comparing Sales data for different customers in same chart

Good day!

My data looks something like this:

CustomerNameOrderNumberSalesAmtOrderDateCustomerGroup
Alpha11000Jan 2017Manufacturing
Alpha22000Jan 2018Manufacturing
Omega3300Jan 2017Education
Omega45000Jan 2018Education
Charlie54000Jan 2017Food 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?

1 Solution

Accepted Solutions
wouterlely
New Contributor

Re: Comparing Sales data for different customers in same chart

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

2 Replies
wouterlely
New Contributor

Re: Comparing Sales data for different customers in same chart

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

leekianteck
New Contributor

Re: Comparing Sales data for different customers in same chart

Hey there, appreciate the links and example.

Will try them out!

Community Browser