Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dani_lopez
Contributor
Contributor

Chart of activation and deactivation of clients

I need to build a chart that shows me every month how many customers buy me now and that they did not buy me before and how many customers bought me in the previous month and now they do not buy me.


This is the grid that i have:

CustomerJanFebMarAprMay
A10--1010
B-1010-10
C--1010-
D10-1010-
E-10-10-


And i need this result:


Feb

2 new customers (B and E) and 2 customers less (A and D) -- i only need the value (2 and 2)

Mar

2 new customers (C and D) and  1 customers less (E) -- i only need the value (2 and 1)

Abr

2 new customers (A and E) and  1 customers less (B) -- i only need the value (2 and 1)

May

1 new customers (B) -- i only need the value (1)

I need this result in a chart... Sorry for my english! I hope you guys can help me.

2 Replies
mdmukramali
Specialist III
Specialist III

Hi dani_lopez



Can you attach some sample data

dani_lopez
Contributor
Contributor
Author

Hi, thnks for your help, this is a little example because the data that i have to work with is to big.