topic Re: Pareto Chart Error in QlikView

Pareto Chart Error

Mon, 06 Jul 2015 20:35:04 GMT

We are trying to create a pareto chart for some of our metrics and are facing issue in them.

The below is the problem description and would appreciate any help in this regard:-

Problem :- We are having the below pareto chart with different bins ; whenever users select a particular set of bins (e.g.:- 0.15 --> 0.23) the calculation automatically changes(Fig 2).

Fig 2:-

Required:- The requirement is not to recalculate as per selection but to retain the values as in Fig-1 ,but with the cropped image. Essentially the values for Fig-2 should have been ( as retained from Fig 1)

Any help is deeply appreciated.

Re: Pareto Chart Error

sunny_talwar — Mon, 06 Jul 2015 20:49:19 GMT

Would you be able to share a qvw file where you are trying this out? Would be easier to work with then to work with the Excel file

Best,

Sunny

Re: Pareto Chart Error

ecolomer — Mon, 06 Jul 2015 20:51:14 GMT

See this example

Re: Pareto Chart Error

Mon, 06 Jul 2015 20:52:07 GMT

Hi Sunny,

Thank you for your prompt reply, I am not able to share the qvw file but have attached the raw data in the excel file as well the result we are trying to achieve, if that would help.

Re: Pareto Chart Error

Mon, 06 Jul 2015 21:00:21 GMT

Hi Enrique,

Thank you for the reply. I checked the solution in the Pareto and the variable.qvw. On selecting any "Solicitante" the %accum column changes, this is what is not required. If suppose , on no selection the accum% for the below shows along with other. I need to have the same accum% also on filtering :-

On only selecting the above 2 , the accum% changes to :-

Re: Pareto Chart Error

sunny_talwar — Mon, 06 Jul 2015 21:03:23 GMT

Try this Expression without full accumulation:

=If(Count(Serial) > 0, RangeSum(Above(Count({<TR_bin = >}Serial), 0, RowNo()))/Count(TOTAL{<TR_bin = >} Serial))

Re: Pareto Chart Error

Mon, 06 Jul 2015 21:09:00 GMT

Not giving the correct result. If I choose Tr_Bin 0.17 it should be

6645/7517 = 88.3% , but the solution does not reflect.

Re: Pareto Chart Error

sunny_talwar — Mon, 06 Jul 2015 21:14:40 GMT

‌I can work on the numbers, the idea was that the percentages don't change based on the selection.

Re: Pareto Chart Error

Mon, 06 Jul 2015 21:20:24 GMT

Hi Sunny,

Sorry for sending the reply in a hurry, I am trying with a little tweak .

Hopefully this should work, fingers crossed. I deeply appreciate your help

in this .

Thanks

Arun

Re: Pareto Chart Error

sunny_talwar — Mon, 06 Jul 2015 23:15:10 GMT

Not a problem. I think my numbers somehow differs from yours, may be because the data is a little different. But again the idea that the percentages should not change when you select bin or bunch of bins works in the example I posted.

Best,

Sunny