Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evgeniystuchalk
Partner - Creator II
Partner - Creator 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
Partner - Creator II
Partner - Creator II
Author

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?

View solution in original post

8 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

Hey there,

Can you give us a sample of your data?

Did you tryed using Set Analysis in this case?

Regards,

MB

vadimtsushko
Partner - Creator III
Partner - Creator III

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
Partner - Creator II
Partner - Creator II
Author

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
Creator III
Creator III

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
Partner - Creator III
Partner - Creator III

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
Partner - Creator II
Partner - Creator II
Author

Sorry, that not works(

evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

Can we speak in russian? Skype, may be?

vadimtsushko
Partner - Creator III
Partner - Creator III

I've sent a PM with skype account