topic Re: Pareto in QlikView

Pareto

Anonymous — Tue, 06 Mar 2012 14:18:08 GMT

Hello

I have this Data (attached as a .qvd) and I want to make a "Pareto" where the 20% of the "Solicitantes" represent the 80% of the "Valor Factura". I want to have a bar/line chart and a pivot table.

I'll be glad to have some help!!!

Thanks

Re: Pareto

Tue, 06 Mar 2012 14:47:45 GMT

Hi Juan,

see the attached example and the BUTTON called Pareto (and here the ACTION tab).

Good Luck!

Rainer

Pareto

Anonymous — Tue, 06 Mar 2012 15:06:54 GMT

Ok, that's great. If I want to see the percentages in the table??? one column for the 20% of the "Solicitante" who represents the 80% of the "Valor Factura"???

Re: Pareto

Wed, 07 Mar 2012 06:45:31 GMT

Good morning Juan,

here are a modified example.

I hope it supports you to get your numbers.

Good Luck!

Rainer

Pareto

Anonymous — Thu, 08 Mar 2012 12:11:03 GMT

Thanks a lot!!! really!!! it was very helpful!

Pareto

Fri, 16 Mar 2012 17:51:53 GMT

Realy very nice post!.. Tks to Rfa!

Re: Pareto

zagzebski — Thu, 01 Aug 2013 02:14:28 GMT

Rainer -

I saw your example and wondered how can I put a variable in the "percentage" box. Every time I do it doesn't recognize it , but if I put a hard coded number in then it does recognize it. Any help is appreciated!

Steve

Re: Pareto

Tue, 06 Aug 2013 13:00:37 GMT

Steve,

sorry for the delay!

I modifyed the example so that you are now able to set a variable.

Good luck!

Rainer

Re: Pareto

zagzebski — Tue, 06 Aug 2013 19:36:07 GMT

Thanks!