Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pareto with negative values

Hi everyone,

I’m working on a sale’s analysis in which it’s crucial to identify which customers have ceased buying or have bought less than last year. Basically identifying our sales loss

I’m looking for 2 things here:

First, a table that ONLY shows those customers in which 2012 sales are larger than 2013 sales. In other words the Customer validation must be done using the total sum of the months selected. This must be dynamic in the sense that said customers might change depending on month selection. (In this example those whose Total sum is negative should appear on the final table, even if an individual month has a positive value). See example for more details.

The second point I’m looking for is create a button that applies a Pareto and selects only those customers who represent 80% of my sales loses.

Any help or insight would be greatly appreciated.


1 Reply
Not applicable

Re: Pareto with negative values