How to create ABC & XYZ analysis in ClikSense?

[sergeybelov]

I use scatter plot to prepare ABC & XYZ analysis of goods. But scatter plot does not have any sorting of dimension to follow bubbles in  ABC X-axis in correct way unlike of QlikView. What should I do to make visualization correct?

[devarasu07 · Accepted solution]

Hi,

check this,

Recipe for a Pareto Analysis – Revisited

ABC Analysis in Qlikview

[sergeybelov]

Thank you for your participation but as I said earlier I know how to do this diagram in QlikView. This is not a problem.

[devarasu07]

the same method used in qlik sense and it's got worked for my case. another link (Henri) solution gave for qliksense.

[sergeybelov]

Ok, I will watch, thanks.

[tomovangel]

Recipe for an ABC Analysis

[sergeybelov]

Thank you, this link was helped me. I should use RangeSum and Aggr functions.

[tomovangel]

No worries
I hope you have found your answer

-Angel

[sergeybelov]

The result is:

Dimension: Client

Measures:

1. ABCD:

max($(Period) 

aggr(

RangeSum(Above(Sum($(Period) [Earn]), 0, RowNo())),

([Client],(=Sum($(Period)  [Earn]), DESCENDING))

)

)

/Sum($(Period) total [Earn])

2. XYZ:

sterr($(Period) aggr(sum($(Period) [Earn]),[Month],[Client]))/

Avg($(Period)aggr(sum($(Period) [Earn]),[Month],[Client]))

3. Earn

Sum($(Period) Earn)

The 'Period' is time-bound analytic set

The sample diagram is:

[Fran_by]

Why are you using sterr() function instead stdev() for calculate XYZ-variation ?