topic cumulative distribution function in QlikView

cumulative distribution function

Tue, 19 May 2009 03:23:41 GMT

I've daily sales of product 1, 2, 3, etc. and I'would like to graph the cumulative percentage of sales for each product until day x. Day and Pruducts are dmensions. Thak you very much for your help, I'm quite new with Qlikview. Roberto

cumulative distribution function

Tue, 19 May 2009 04:24:50 GMT

I would try the two checkboxes/radio buttons in the Properties->Expressions tab of the chart object:

-Full Accumulation

-Relative

cumulative distribution function

Tue, 19 May 2009 04:34:16 GMT

Thak you Eugene for your quick reply but your suggestion works fine for absolute values.

It doesn't work with percentage. Is it possible to calculate the cumulative distribution using functions or set analysis?

Roberto

cumulative distribution function

johnw — Tue, 19 May 2009 05:11:14 GMT

The cumulative percentage should be a combination of the "Relative" and "Full Accumulations" radio buttons, as said. That is giving a cummulative percentage for me. What are you seeing?

cumulative distribution function

Wed, 20 May 2009 03:04:33 GMT

Thank you very much John, now it works!!!

I've managed to solve my problem using your suggestions.

Regards.

cumulative distribution function

johnw — Wed, 20 May 2009 03:10:41 GMT

Heh, well, thanks, but all I was doing was reiterating what Eugene said. Glad it worked, though.