Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

evgeniystuchalk
Contributor II

another approach to ABC analysis - need help

Hello! i'm already applyed method from this guide: Recipe for an ABC Analysis

But now i need another approach:

in Recipe for an ABC Analysis we get results like "how much best 20% clients makes money for me". I need solve this in key "Who is this clients, who makes 80% money for me".

I make this table:

c59028243a.jpg

It counts accumulative percentage for clients, that sorted by decease of Delta. Formula:

RangeSum(Above(sum(Дельта)/sum(TOTAL Дельта),0,rowno()))

ABC - its measue with formula:

If(RangeSum(Above(sum(Дельта)/sum(TOTAL Дельта),0,rowno()))>0.95,'C',

If(RangeSum(Above(sum(Дельта)/sum(TOTAL Дельта),0,rowno()))>0.80,'B','A'))

Now, i want to select all 'A' clients in one click. That means i need calculate ABC as Dimension. And i have problem with it.

When im changing formula of ABC like this:

aggr(If(RangeSum(Above(sum(Дельта)/sum(TOTAL Дельта),0,rowno()))>0.95,'C',

If(RangeSum(Above(sum(Дельта)/sum(TOTAL Дельта),0,rowno()))>0.80,'B','A')),[Brand name])

And switch it type to Dimension, it brokes my accumulative percentage, end calculated incorectly:

afaeb6d25a.jpg

What i must change in my formulas?

1 Solution

Accepted Solutions
evgeniystuchalk
Contributor II

Re: another approach to ABC analysis - need help

Privet, Vadim

Well, because this project we made for Qlik Sense Desktop, i find parial solution: use extension of Slider Variable, that controls client percentage in A group.

ABC dimension counts like in Recipe for an ABC Analysis

23492c651d.jpg

So i can adjust it for each selection, to include in Group A 80% of Delta)

Vadim, what do you mean about "we went full scale into mashup environment"? It possible to make in Qlik Sense Server?

8 Replies
miguelbraga
Valued Contributor III

Re: another approach to ABC analysis - need help

Hey there,

Can you give us a sample of your data?

Did you tryed using Set Analysis in this case?

Regards,

MB

Highlighted
vadimtsushko
Contributor III

Re: another approach to ABC analysis - need help

Hi, Evgeny.

I believe that's not possible in standard Qlik Sense application. We have same requirements and only recently, when we went full scale into mashup environment that kind of scenarios become possible for us.

It looks like this:

2016-09-06_13-28-25.png

Recipe for that is to dynamically prepare formula for ABC calculated dimension on every change in selection. (In our case on every change in selected dimension, selected measure, and ABC border values too).

I've tried to do something like that with Qlik Sense extensions, but I believe that's is not possible yet.

evgeniystuchalk
Contributor II

Re: another approach to ABC analysis - need help

Privet, Vadim

Well, because this project we made for Qlik Sense Desktop, i find parial solution: use extension of Slider Variable, that controls client percentage in A group.

ABC dimension counts like in Recipe for an ABC Analysis

23492c651d.jpg

So i can adjust it for each selection, to include in Group A 80% of Delta)

Vadim, what do you mean about "we went full scale into mashup environment"? It possible to make in Qlik Sense Server?

jayaseelan
Contributor III

Re: another approach to ABC analysis - need help

Hi,

Please try following expression. if you got your output reply us.

    Aggr(If((Rank(Sum(Дельта),1)-1) / Count(distinct total BrandName)< 0.50, 'A', 

      If((Rank(Sum(Дельта),1)-1) / Count(distinct total BrandName)< 0.75, 'B', 'C')),BrandName)

Thanks,

vadimtsushko
Contributor III

Re: another approach to ABC analysis - need help

Interesting. Probably that's the best approach available in standard Qlik Sense.

We, basically, are doing very similiar thing, only we calculate parameters for ABC dimension formula automatically, using Qlik Sense API.

Vadim, what do you mean about "we went full scale into mashup environment"? It possible to make in Qlik Sense Server?

Mashups can be deployed both in Qlik Sense Server and Desktop environment, AFAIK. But I've tried it only with Qlik Sense Server.

evgeniystuchalk
Contributor II

Re: another approach to ABC analysis - need help

Sorry, that not works(

evgeniystuchalk
Contributor II

Re: another approach to ABC analysis - need help

Can we speak in russian? Skype, may be?

vadimtsushko
Contributor III

Re: another approach to ABC analysis - need help

I've sent a PM with skype account