# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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:

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:

What i must change in my formulas?

1 Solution

Accepted Solutions
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

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
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
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:

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.

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

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?

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,

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.

Contributor II

## Re: another approach to ABC analysis - need help

Sorry, that not works(

Contributor II

## Re: another approach to ABC analysis - need help

Can we speak in russian? Skype, may be?

Contributor III

## Re: another approach to ABC analysis - need help

I've sent a PM with skype account