Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
fabianaiglesias
Not applicable

Paretto in Qlik sense

Hi,

I need to make a Pareto graph with its respective table.


The data are the following:
- Department
- Date
- Account code
- Account
- Money
- Accounting account


I need to be able to filter the data according to:

- Month

- Year

- Accounting acount

- Department

- Paretto Group (A, B or C)


Additionally, I want the bars of the graphic to be colored according to the following:

- Group A: red

- Group B: yellow

- Group C: green


Y axis values:


- Group A: accounts that represent 80% or more of the prorated money

- Group B: accounting accounts that represent less than 80% and 50% or more of the prorated money

- Group C: accounting accounts that represent less than 50% of the prorated money


I created the variable vParetto like this:


Aggr( If((Rank(Sum(Dinero*Porcentaje),1)-1) / count(distinct total (Dinero*Porcentaje))< 0.20, 'A',If((Rank(Sum(Dinero*Porcentaje),1)-1) / sum( total (Dinero*Porcentaje))< 0.50, 'B', 'C')),Descripcion)


and used the same expresion in the graph (“Appearance” – “Colors and Legend” - "Colors") and in the filter "Paretto", but it´s not working in any of the 3 cases. The filter is not working properly either.


I will appreciate any help you can give me


3 Replies
pradosh_thakur
Not applicable

Re: Paretto in Qlik sense

did you go through this already?

Recipe for a Pareto Analysis – Revisited

Learning never stops.
fabianaiglesias
Not applicable

Re: Paretto in Qlik sense

Hi Pradosh,

yes, I did it.

But it´s not working either:

The % are not properly calculated

Apparently, "desc" it´s not working, and I don´t know why.

I´m using Qlik Sense Desktop, february 2018 version

pablolabbe
Not applicable

Re: Paretto in Qlik sense

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others